Invoice calculation help needed

[TehSparrow via AccessMonster.com]

I have made an invoice from a report, but i need it to be a weekly run thing.
i want a formula for a query that allows me to enter todays date, and the
formula then adds on 7 days, thus to display a weeks results.

ive tried so many different things but nothing seems to be working, Any help
will be greatly received!!!!

Sparrow

 

[TehSparrow via AccessMonster.com]

Is This right?

BetweenDate() And DateAdd("d",7,Date())

 

[Douglas J Steele]

There needs to be a space between Between and Date():

Between Date() And DateAdd("d",7,Date())

 

[Guest]

Have you tested it?
Except for missing a space after the word Between, it appears to be correct.
Be aware however, if you will actually be getting 8 days. For example, if
you use today's date 4/4/2006, it will be Between 4/4/2006 and 4/11/2006,
which is actually a week + 1 day. It will return all records for both those
dates. It is the same as coding >= 4/4/2006 ans <= 4/11/2006. To get an
actual calander week, you should change it to +6

 

[TehSparrow via AccessMonster.com]

Wondered why i was getting 8 day weeks!!!!

Thanks everyone!

S