expressions Help

[anitra_tanner]

Hello,

I am trying to add together 2 expressions created in my query. I would
like to do this in the query because I am creating a report that will
include several queries. Ive read that you should do the totals on the
report but I will get confused if I have too many totals on the page to
calc. In all I believe I will have about 9 queries populating this one
report. So is there a way to add 2 expressions together in the query?

Also is there a limit to how many queries you can use in one report.
The project that I am working on is trying to recreate a handwritten
report with lots of averages and totals by past week, average of month,
average of 2 months, for open orders, past due orders and forecasts.

Thanks for your help I love this group!

 

[Guest]

Adding to expressions together is easy.
Ordered: IIF([Due] = "X", [QTY], 0) + IIF([Del] = "X", [QTY], 0)
This adds the QTY of Due items to QTY of Delivered items.

You might think about using a subreport for each of the 9 queries unless
they must be calculated together also. Then you might use a 10th query and
subreport for those calculations.