Two Queries with two date fields???

[zacharyjunior]

I seem to be stumped. I have two queries that I need to generate a report with. The first query has a field complaint date, and the second query has an invoice date. I need the dollars associated for a particular time frame.

Complaint Date - What cost is associated during that time.
Invoice date - What invoices were paid during this time.

My question is how do I query against two diffrent dates?

Thanks

 

[zacharyjunior]

Sorry for the double post. Pat, where do you put this line at in the query?

Where ComplaintDate Between [Enter Start Date] And [Enter End Date] OR InvoiceDate Between [Enter Start Date] And [Enter End Date];

 

[zacharyjunior]

Pat,

I am still having a problem. I understand the part of entering the Between [Start Date] and [End Date] in the criteria part of each date. This is not a problem. The problem is that the correct data is only returned for the Invoice cost. The order total $ has the same amount and the order date is the same.

Any suggestions?

 

[GinaO]

Hi,

You could try writing two separate queries and then doing a union of both.

I have the same problem & this kinda worked out.
Hope this helps .

Gina.