CAN you use SQL as the control source?

[xicana]

I need a text box to show something like this:

if txtPeriod < 07 then
select NumSold
where itemNo=txtItem and year=2004
else
select NumSold
where itemNo=txtItem and year=2003

i know this isn't the right syntax - just trying to relay the logic.

The query that is the underlying source of the report holds the information that I need...I just need to set those conditions.



Sandy

 

[xicana]

I just read the thread right below mine...
I'll try to use the dlookup function and see if that works

Sandy