Query on IF Statements MAX Date
Novice
Windows XP 
Access 2007
Hello,
I need help with 3 queries to populate fields – FindingRemediationDate, DateRange and MaturityofFinding in the Finding and Rec Aging Report table in the E2E F&R Tracking DB. I have attached query scenarios and files for illustration purposes with instructions in a word document. Please don’t hesitate to ask should you have questions and thanks.
Happy New Year!
VIP
Windows 7 64bit Access 2010 32bit
Saving calculated data, especially aggregate data, is usually not recommended. The same SELECT query that calcs the data for saving to table can just be used like a table. No need to save the data.
What exactly is not working with your structure - error message, wrong results, nothing happens?
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.
Query Criteria Using IIf Statements
Posting Permissions
Reply With Quote