Pull a date range into multiple queries
Is there a better way, to enter the new date range somewhere and have all the queries pull the date range from that one location
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Since I have over a 100 queries to accomplish the massive reporting involved, I really don't want to do this individually.
About have the queries use a "between" date range and the other half are grouped by month so they use a "month year" range. Most of the queries have multiplecriteria so the date criteria might be used up to 10 times in one query.
I want to use a query to calculate how many records have been created within the date range entered for each table and then summarize this on a report. I only want the user to enter the date range once.
Using dCount on the report itself has proved useless. I have copied syntax from other posts talking about dCount and copied code from Microsoft's own website and Access doesn't like it. So, is there any way of getting these counts without running about 40 queries and a load of queries based upon the queries to get the counts?
I have three different reports which all work off a user specified date range. I have created a macro to run them and as long as I specify "Between And" conditions in the queries behind them the macro works fine, but you have to enter the date range three different times.
Is there a way to specify the date range once in the macro so that all the reports run for that date range
The query building was coming along swimmingly until the users requested a date range. I have a date range selection that can look at any cases within the date range. This part is not working currently.
This is what the form generates. Get all cases with these specific parameters within this date range.
The problem ends up being that I get cases with received dates within the range and closed dates outside of the range or vice versa.
2) Any thoughts on how to fix this?
However, I have a button that this form page that will run ANOTHER query to show the detail, in other words, line by line data. What Ido not like is how the user has to enter the date range again.
Is there a way, I can have the date range entered for both queries only one time? this way, when the date range is entered, the user goes tot he summary form query, but can click a buttonto see the detail lines without having to enter in another date range?
tblBlackout has a Date Range where we can not visit the property. I would like to enter a Start Date and End Date in a form, lets say Forms![FormName]![SDate] and Forms![FormName]![EDate] and have it show all properties that can be visited in that range.
I need to count this data different ways and have created several Crosstab Queries:
1) Number of shifts worked by Employee
2) Number of customers helped by employee and shift
3) Total number of customers helped
4) Total of overdues with breakdown by date (count of Date)
These all work great and give me exactly what I need. However, I need to be able to enter a date range and have the totals from each of the above queries reflect that date range so that I have one report that shows the employee, how many shifts were worked for the time period, how many customers were helped, and how many tasks were not completed on time (this comes from thedate field).
Do I have to create separate queries, entering the date range for each, or is there an easier way?
I want to combine all the data from the 3 tables and get the sum of all the prices with a given condition that the query date should be within the range of date from and to of all tables. Worst scenario, all date from and to are not equal.