aussie_user
Registered User.
- Local time
- Today, 14:15
- Joined
- Aug 6, 2002
- Messages
- 32
Hi,
I have a database that tracks when progress reports are due (up to 12 different reports) and when they are received.
My fields are FirstReportDue, Second Report Due etc and FirstReportRecd, SecondReportRecd etc.
I need to create a report that will show what reports are due in a given month so I need to create an appropriate query. I understand how to set the criteria to get the correct dates however I would like to know if it is possible to add something to the effect of " If FirstReportRecd is Null then show date for FirstReportDue.
Also there are only 9 lines for criteria but I need 12 so that I can capture data from any of the 12 fields where a Report is Due. Does anyone know how to get around this restriction?
Thanks for any help or suggestions.
I have a database that tracks when progress reports are due (up to 12 different reports) and when they are received.
My fields are FirstReportDue, Second Report Due etc and FirstReportRecd, SecondReportRecd etc.
I need to create a report that will show what reports are due in a given month so I need to create an appropriate query. I understand how to set the criteria to get the correct dates however I would like to know if it is possible to add something to the effect of " If FirstReportRecd is Null then show date for FirstReportDue.
Also there are only 9 lines for criteria but I need 12 so that I can capture data from any of the 12 fields where a Report is Due. Does anyone know how to get around this restriction?
Thanks for any help or suggestions.
