Would this be a IFF then Statement?

[Corey]

Hi again everyone,

I'm stumped again.

I have two reports that my query is looking at.
One is:
1. ProgramActByDay
And the other is:
2. ProgramByProductByDay

What I'm trying to make it do is is to find a cretin program ID then look at a different report and use criteria to populate the sales,

Maybe this will make since

IIF ([Program_ID.ProgramActByDay] = 1667100
Then go to a different report titled: ProgramByProductByDay

And look for
All Program ID = 0
All Product ID = 38648800
All Locale = en_US
Only calculate the data for the current month
Then total all the sales
And put it in the sales field

 

[KeithG]

How do you base a query of a report? Are your reffering to the recordsource of the report?

 

[Corey]

Does this make Sense?

IIF ([Program_ID] = 1667100

Then go to query
ProgramByProductByDay

Field->Program ID = 0
Field->Product ID = 38648800
Field->Locale = en_US
Field->Report_Date = Current Month


Then total all the sales in the Sales Field

Then put the total from the sales back into the
ProgramActByDay query,