Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010

    Unanswered: Query Dates for Multiple Fields

    Hi all,

    I'm trying to create a label printing query for a mail order system that looks in a table for the date and also how it was sent.

    The tables I'm using are: Customers and CurrentOrders (customer details appear on CurrentOrder table).

    CurrentOrder table is set out as follows:

    ID, Customer (linked to surname and address), DateRec, HowRec, Status, DateSent, HowSent, ToFollowSent, ToFollowHowSent

    I'm currently have a system where it displays info for those being sent on a date entered and a courier entered (eg - 12/11/10 and Company1). It works.

    However, a customer might be having a to follow sent out on the 12th with Company1 as well, no matter how I've tried, I just can't get it to work. I've had the same syntax entered in DateSent and HowSent to the ToFollow fields but it doesn't work, it ends up displaying no information.

    Could someone please help me with this? Thank you

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    It is likely a normalization issue to have the numerous date fields in one record, but this type of thing:

    WHERE DateRec = #12/11/10# OR DateSent = #12/11/10# OR ToFollowSent = #12/11/10#

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts