between dates criteria

[alxj]

I want to enter a date and have it display results between the specified date and 6 days later.

I have tried criteria
Between [From] And ([From]+6)

it works for numbers but not for dates
anyone got any ideas?

 

[DJBummy]

Try this:

Between [From] And DateAdd("d",6,[From])

D.J.

 

[alxj]

Cheers DJBRUMMY
you probably wont believe it but i got it to work 2 mins before your Post using exactly the same method.

Many Thanks Anyway
Alex