Ms Access Reports question

blink496

Don't know if anyone can help me with this? I need to create a report that gives me the data from the previous accounting week. For example, if I try to display the report on a wednesday, it will give me the data from monday to sunday of the previous week. The same thing will happen if I print the report on thursday. I.E. I should still get the same data from the previous accounting week (ie mon to sun).
I know how to manually set parameters in the query that feeds the report, but I'm thinking that there must be a more automated way of doing this. Hope I made myself clear? Help appreciated.:)

Seth Brundle

See if this is any help...
http://groups.google.ie/group/microsoft.public.access.queries/browse_thread/thread/ab6e2d9c0ffcdf17/100d3daa2e151a8d?lnk=st&q=access+vba+dates+of+last+week&rnum=1&hl=en#100d3daa2e151a8d

Gosh

Try using this as the selection criteria for your date

>=DateAdd("d",-7-(Weekday(Now())-1),Now()) And <=DateAdd("d",(-6-(Weekday(Now())-1)+6),Now())

Whatever day of the week you're on it should return the Mon-Sun of the previous week

blink496

Thats perfect, thanks!