How to have report use more than one query

[home70]

I have a table that contains transaction info including the date of the trans and the date of the order. Some orders do not have a transaction date yet. I'd like to have a report that shows a total dollar amount on all the orders and also shows the total dollar amount of orders that do have a transaction date.
It seems like I would somehow need to be able to have the report use two different queries, but I don't know how to do this.
Can anyone tell me how to do that?
Thanks.

 

[grnzbra]

I am assuming that you want to select a particular transaction date or date range and then all where transaction date is null.

You could create two queries, one with the transaction date criteria and one where the transaction date criteria is null and then use them to drive a union query which would drive your report.

You might even be able to create the union query by itself and include the appropriate criteria in each section, but I don't know if union queries would allow that. I just checked the help files and it seems that you can do that.

 

[home70]

I found out how and used what I believe are called "calculated fields" on the report to display the info depending on criteria in the calculation for the field.