Date +7

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use this as your criterion expression:

Between [Enter the starting date:] And DateAdd("d", 7, [Enter the starting
date:])
 
Put the following expression in the criteria of your date field:
Between Date() And DateAdd("d", 7, Date())
 
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.
 
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...
 
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...
 
Back
Top