T
Thorson
I am having problems pulling in the information I want from my query to my
report due to table relationships.
I have created a report from a query that shows the number of animals sold,
died or transferred for the month. This query comes from a disposition
table, every animal that is sold, died or transferred has an individual
disposition number and is entered into the disposition table, all the query
does is sum the number in each category for the month, it also is limited by
1 of 3 different animal units. In a separate table is a list of all animals
born, I have created a query to count the animals born for the month, this
query is also limited to 1 of 3 different animal units.
I created a third query to tie the first two queries together, I linked them
by the Animal Unit each query was orginally limited to. I then created a
report to show all the animals sold, transferred, died, or born for a
specified month, by animal Unit.
My problem is that if a unit has animals that are born but no animals that
had disposition records (died, transferred, sold) no results show up because
of the join properties in the third query. So I changed it so that all
disposition records will show up in the query but only birth records that are
equal, this works except for when a unit only has birth records and no
dispostion records.
Does anyone have any suggestions? Can I set up a report to pull from 2
different queries? Do I need to change the format of my third query?
report due to table relationships.
I have created a report from a query that shows the number of animals sold,
died or transferred for the month. This query comes from a disposition
table, every animal that is sold, died or transferred has an individual
disposition number and is entered into the disposition table, all the query
does is sum the number in each category for the month, it also is limited by
1 of 3 different animal units. In a separate table is a list of all animals
born, I have created a query to count the animals born for the month, this
query is also limited to 1 of 3 different animal units.
I created a third query to tie the first two queries together, I linked them
by the Animal Unit each query was orginally limited to. I then created a
report to show all the animals sold, transferred, died, or born for a
specified month, by animal Unit.
My problem is that if a unit has animals that are born but no animals that
had disposition records (died, transferred, sold) no results show up because
of the join properties in the third query. So I changed it so that all
disposition records will show up in the query but only birth records that are
equal, this works except for when a unit only has birth records and no
dispostion records.
Does anyone have any suggestions? Can I set up a report to pull from 2
different queries? Do I need to change the format of my third query?