UNC_Access
Registered User.
- Local time
- Yesterday, 20:23
- Joined
- Oct 24, 2012
- Messages
- 42
Hi! Here is my idea/issue:
1. I have created query that has the following expression/field:
Days Outstanding: [Reporting Date] - [Table1].[Filing Date]
2. [Filing Date] is contained in a [Table1] of course. But [Reporting Date] is not in any table. I guess it is a query parameter.
3. I want [Reporting Date] to come from a single source, such as a form input. This [Reporting Date] is the same date for all records (it is the month end). For example, let us say the current reporting date is 1/31/13.
4. My issue is that my form will not save this reporting date of 1/31/13. When I save, exit, and return, it is gone.
How can I save the reporting date in the form?
I would like to do this so that I can run the query in step (1.) above without having to open the form and re-type the date.
Thanks!
1. I have created query that has the following expression/field:
Days Outstanding: [Reporting Date] - [Table1].[Filing Date]
2. [Filing Date] is contained in a [Table1] of course. But [Reporting Date] is not in any table. I guess it is a query parameter.
3. I want [Reporting Date] to come from a single source, such as a form input. This [Reporting Date] is the same date for all records (it is the month end). For example, let us say the current reporting date is 1/31/13.
4. My issue is that my form will not save this reporting date of 1/31/13. When I save, exit, and return, it is gone.
How can I save the reporting date in the form?
I would like to do this so that I can run the query in step (1.) above without having to open the form and re-type the date.
Thanks!