Hello,
I have a query with with about 40 expression generated expiry dates, how do I create a query to show all units that expire on a particular mm/yyyy format?
Dave
Hello,
I have a query with with about 40 expression generated expiry dates, how do I create a query to show all units that expire on a particular mm/yyyy format?
Dave
Maybe a query with 40 OR operators in the WHERE clause?
You should probably apply filter to a simple SELECT query then use that query as source for your 40 calcs query.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Ya, that might work, I'll giver a go...