Microsoft Access Help

sfx · 30 Mar 2006 at 09:04

Hi,

I need to return the records between two dates. Now I know I can to Between Date1 And Date2. But I dont want to have to change it all the time.

Can I do something like Between Date()-4 And Date() - I have tried this but it does not seem to work. What I want to do is return the results for 5 days, so if it is friday get from monday to the current friday.

Any help will be great.

Cheers,

sfx

sfx · 30 Mar 2006 at 14:20

ClearChaos said:
one of these should do the trick

Functions for calculating and for displaying Date/Time values in Access

Brilliant, sorted now thanks.

sfx