Report on two queries

E

EliotF

I am trying to construct a report on the production of a job.
I would like to create the cost of production and materials.
To do this I would like to display the results of two different queries, one
with a breakdown of material details and the other with a breakdown of
production costs.
THe two items can be linked by an Job ID number but other than this they
have very few simialrities that can be linked together.

I have tried to creat a single query combining the two but am having no
success.

Can someone help me?

EliotF
 
P

Paul (ESI)

Job ID should be enough to link them. Is Job ID unique in both tables? Can
you be more descriptive of your problem, though? If you clarify, we will have
a better chance of helping. What happens when you try to perform the query
combining them? Does nothing show up? Do you get an error message? What
version of Access are you using?

Also, it might help if you tell us the fields involved, as well as what
table or tables are being used in these queries. It might also help to show
the SQL for the queries. To do so, go in the design view of the queries,
click view, then click "SQL view." Copy and paste what you see.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor
 
Top