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.