I have a query (access2000) that prompts users for a date range. I used the following code in the criteria section of the date field in my query:
Between [Please enter the start date - mm/dd/yy] And [Please enter the end date - mm/dd/yy]
Is there any way to trap this data and store it in a global variable? I'm trying to solve a problem with my report, which is that I'm not supposed to display certain records in the report, but I need to know the total number of records for some calculations (if I use a filter, some records get excluded, and my calculations get screwed up). The only way I could think of to solve this problem is to run the report from two queries, one that filters the data, and one that doesn't. I don't want the user to have to enter the date range twice, though......
Any help would be greatly appreciated!
Kevin
Between [Please enter the start date - mm/dd/yy] And [Please enter the end date - mm/dd/yy]
Is there any way to trap this data and store it in a global variable? I'm trying to solve a problem with my report, which is that I'm not supposed to display certain records in the report, but I need to know the total number of records for some calculations (if I use a filter, some records get excluded, and my calculations get screwed up). The only way I could think of to solve this problem is to run the report from two queries, one that filters the data, and one that doesn't. I don't want the user to have to enter the date range twice, though......
Any help would be greatly appreciated!
Kevin