Three queries into one report?
It looks like using subreports should do what I need. But I'm having a
problem with them. I'm trying to display three subforms in the detail
section of the main form. The first two work fine, but the third one only
displays the label for the third subform. I've tried resizing it, deleting
and reinserting it, making sure the relationships are set...but it's not
working. When I open the problematic subform on its own everything is
displayed. Any ideas about what might be wrong?
Sean Marsell
Quote:
>One option is to use subreports in your report.
>Read online help on "Create a subreport". After that, if you're still
stuck
>come back and ask specific questions to help you through the process.
>> Hi,
>> I have three queries that each contain a Date and a Product Field, with
the
>> remaining fields being different in each. I need to select records from
the
>> queries based on the Date and Product values and group them together in a
>> report. It should look like this:
>> Product 1
>> Date1
>> Query1 info
>> Query2 info
>> Query3 info
>> Date2
>> Query1 info
>> Query2 info
>> Query3 info
>> Product 2
>> Date1
>> Query1 info
>> Query2 info
>> Query3 info
>> etc.....
>> Getting the information from only one query into a report is not problem,
>> but I'm not sure how to combine all three queries into one report. Is
there
>> a way to weave all of this together, or will I have to settle for
different
>> reports for each query? Or is there a way to combine all three queries,
>> even though they contain dissimilar fields? Thanks in advance,
>> Sean Marsell
