Report need data from table 2 different ways

[rinmanb70]

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 two different type of
totals on these transactions. On the report, I need both the total
dollar amount on all orders (even if there is no transaction date) and
also the total dollar amount of orders that do have a transaction date.
It seems like I would need 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.

[Bob Quintal]

"rinmanb70" <em**********@gmail.comwrote in
news:11*********************@p79g2000cwp.googlegro ups.com:

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 two different type of totals on these transactions.
On the report, I need both the total dollar amount on all
orders (even if there is no transaction date) and also the
total dollar amount of orders that do have a transaction date.
It seems like I would need 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.

no, use one query. Use one calculated field, which determines if
transaction date is null, and replaces the amount with 0 for
that row.

amtComplete: IIF(isnull([dateTransaction]), 0, [dollar amount])

then just show the sums of both [dollar amount] and amtComplete
on the report.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[rinmanb70]

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.