Invoice calculation help needed

  • Thread starter TehSparrow via AccessMonster.com
  • Start date
T

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
 
T

TehSparrow via AccessMonster.com

Is This right?

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

Douglas J Steele

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

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

Klatuu

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
 
T

TehSparrow via AccessMonster.com

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

Thanks everyone!

S
 
Top