Thanks Graham you hit the nail on the head.
I sat and worked out all the permutations and then tried to build a query for this and it had about 7 OR's and 8 AND's which ended up being longer than my arm.
You came along and did it in a one liner!! I obviously could not see the forest for all the trees.
Thanks again Graham
Tony
tonymcc
Last Activity: Mar 21 '09, 09:07 PM
Joined: Dec 2 '08
Location:
-
Find records within a date range
Hi all
I am having a head bursting nightmare trying to get a query to work, I will try and explain.
I have developed a database for the calculating storage costs in a warehouse. Customers are charged a daily rate while their pallets are stored in the depot warehouse. I have fields in a table called DateIn and dateOut both are short dates. I have forms to book pallets in and book them out and I can see all is fine...
No activity results to display
Leave a comment: