S
Stuart
I have a database which has two tables containing information. The
information held on these tables is things like supplier, equipment
description, management costs, section, etc. I have run from this a selection
of queries showing the information for equipment which I have a quote for and
items which are unquoted.
The unquoted equipment has been grouped together by section. This is to show
what figures are still unquoted for but is included in the estimation.
The quoted equipment is more detailed, in that it shows all the equipment
and the costs instead of being summed up.
Now I am trying to run a report which will join these two queries into the
one report. I am hoping it is possible that I could lay out the report so
that when I have the quoted equipment detailed and then a one line entry
showing the unquoted equipment. This is so that the figures add up without
having two reports or one very large report.
information held on these tables is things like supplier, equipment
description, management costs, section, etc. I have run from this a selection
of queries showing the information for equipment which I have a quote for and
items which are unquoted.
The unquoted equipment has been grouped together by section. This is to show
what figures are still unquoted for but is included in the estimation.
The quoted equipment is more detailed, in that it shows all the equipment
and the costs instead of being summed up.
Now I am trying to run a report which will join these two queries into the
one report. I am hoping it is possible that I could lay out the report so
that when I have the quoted equipment detailed and then a one line entry
showing the unquoted equipment. This is so that the figures add up without
having two reports or one very large report.