Changing Criteria Parameters

[tuktuk]

I have a report that is build on monday where a module runs qrys and exports to an excel file.

my issue is that every Monday i need to chagne the date criteria on all of the 9 queries.

for example: qry_PostPriceBanding has a criteria ">=#5/16/2011#" set on a field called "SendDate". this data was correct for the run yesterday but when Monday 7/25/11 comes around i'll need to add 7 days to the criteria ">=#5/16/2011#" to get the desired output.

is there an easy way to do this? can it be done using vba?

thanks
tuk

 

[xenou]

Okay. Another shot (if you still can't get it to work directly with the crosstab) is to set it up with a normal select query with your parameters and criteria etc., then run the cross tab off of that query.

Offhand, I'm not sure about crosstabs in this situation but it looks like you've got a good source to go from with the web page from Allen Browne.