Date query in Microsoft Access

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ccee

Thread Starter
Joined
Nov 4, 2011
Messages
1
Help! I'm using Microsoft access 2003. I have clients that are booked in for a block of ten treatment sessions. I can only schedule SMS reminders for them a week in advance. I need to create a query that allows me to see who is due for an SMS reminder in the next two weeks ie who has a treamtent coming up. Treatments are entered in as Treatment 1, Treatment 2 etc. When I add all the 10 treatments on as fields in a query in design view and enter the code <Date()+14 for all of them, it comes up with nothing. However, the query works if I only have Treatments 1 and 2 added, as all clients will have these treatments coming up (they aren't up to the later treatments yet). Is there a way that the fields can be searched as an "or" rather than "and" ? Do I need to change the code? I don't want to have to run a separate query for all ten treatments!
I'm an academic and a health practitioner and really not very good on Access! hope you can help
 
Joined
Jul 29, 2001
Messages
21,334
In your query designer if you put the criteria all all on the same criteria row it will be an AND. If you put them on separate lines for each column it will be OR
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top