Date +7

D

DianeandChipps

I would like to run a query which will print a list of records for the
following week. I would like to enter the start date and for the query to
automatically print all records starting on that date for 7 days. The only
way I have been able to do it is to set 2 criteria, one which asks for a
start date and one which asks for an end date.
Does any clever person know a better way to do this?

Many thanks.
 
K

Ken Snell [MVP]

Use this as your criterion expression:

Between [Enter the starting date:] And DateAdd("d", 7, [Enter the starting
date:])
 
P

PC Datasheet

Put the following expression in the criteria of your date field:
Between Date() And DateAdd("d", 7, Date())
 
D

DianeandChipps

Thank for your time. I want to add the start date so the report can be run
in advance. Ken Snell has given me the correct way around this.
Many thanks.
 
D

DianeandChipps

Thanks very much that is just what I meant, it works perfectly.

Ken Snell said:
Use this as your criterion expression:

Between [Enter the starting date:] And DateAdd("d", 7, [Enter the starting
date:])


--

Ken Snell
<MS ACCESS MVP>

DianeandChipps said:
I would like to run a query which will print a list of records for the
following week. I would like to enter the start date and for the query to
automatically print all records starting on that date for 7 days. The
only
way I have been able to do it is to set 2 criteria, one which asks for a
start date and one which asks for an end date.
Does any clever person know a better way to do this?

Many thanks.
Click to expand...
Click to expand...
 
K

Ken Snell [MVP]

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

DianeandChipps said:
Thanks very much that is just what I meant, it works perfectly.

Ken Snell said:
Use this as your criterion expression:

Between [Enter the starting date:] And DateAdd("d", 7, [Enter the
starting
date:])


--

Ken Snell
<MS ACCESS MVP>

message
I would like to run a query which will print a list of records for the
following week. I would like to enter the start date and for the query
to
automatically print all records starting on that date for 7 days. The
only
way I have been able to do it is to set 2 criteria, one which asks for
a
start date and one which asks for an end date.
Does any clever person know a better way to do this?

Many thanks.
Click to expand...
Click to expand...
Click to expand...
 
Top