1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Date query in Microsoft Access

Discussion in 'Business Applications' started by ccee, Nov 4, 2011.

Thread Status:
Not open for further replies.
  1. ccee

    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
     
  2. Rockn

    Rockn

    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
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1025371

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice