By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,627 Members | 1,188 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,627 IT Pros & Developers. It's quick & easy.

Report need data from table 2 different ways

P: n/a
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.

Aug 21 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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

Aug 21 '06 #2

P: n/a
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.

Aug 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.