display an array of dates

[Guest]

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

 

[Douglas J. Steele]

Try

Between [Date] And [Date] + 3

 

[Guest]

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

thanks for trying

Try

Between [Date] And [Date] + 3


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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

 

[Guest]

Post the complete text of the query

 

[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!)

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

thanks for trying

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