display an array of dates

C

Christopher Buxton

I have a table that contains a large number of records, each of which is a
job. Each record has a date that we need to do the job.

I also have a query that displays all the jobs for a particular day by
having [Date] in the criteria for the date column.

I need to get the query to display jobs for the date I input plus the next 3
days after that. I thought the following would work but it doesn't:

[Date] AND [Date]+1 AND [Date]+2 AND [Date]+3

What function do I need to use in order to achieve my goal?


Thanks

Chris
 
C

Christopher Buxton

thanks anyway but that still didn't work. same error message as before. says
that expression is incorrect or too complex.

thanks for trying

Douglas J. Steele said:
Try

Between [Date] And [Date] + 3


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Christopher Buxton said:
I have a table that contains a large number of records, each of which is a
job. Each record has a date that we need to do the job.

I also have a query that displays all the jobs for a particular day by
having [Date] in the criteria for the date column.

I need to get the query to display jobs for the date I input plus the next
3
days after that. I thought the following would work but it doesn't:

[Date] AND [Date]+1 AND [Date]+2 AND [Date]+3

What function do I need to use in order to achieve my goal?


Thanks

Chris
Click to expand...
Click to expand...
 
D

Douglas J. Steele

You never mentioned there was an error...

As Ted suggested, post the SQL associated with your query.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Christopher Buxton said:
thanks anyway but that still didn't work. same error message as before.
says
that expression is incorrect or too complex.

thanks for trying

Douglas J. Steele said:
Try

Between [Date] And [Date] + 3


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



in
message news:[email protected]...
I have a table that contains a large number of records, each of which is
a
job. Each record has a date that we need to do the job.

I also have a query that displays all the jobs for a particular day by
having [Date] in the criteria for the date column.

I need to get the query to display jobs for the date I input plus the
next
3
days after that. I thought the following would work but it doesn't:

[Date] AND [Date]+1 AND [Date]+2 AND [Date]+3

What function do I need to use in order to achieve my goal?


Thanks

Chris
Click to expand...
Click to expand...
Click to expand...
 
Top