Thanks for the replies. I actually used something very similar to ADezii
I'm now working thru the reports that don't have any records and dealing with sub reports.
User Profile
Collapse
-
Have you tried REFRESH in the on change property of the combo box?Leave a comment:
-
Not sure about the code, here is what I do for date ranges
On the form you created, name one field begindate and the other enddate.
The user will enter the dates on this form. This form could also have a list box with your reports, or command buttons for the report...I always call this form F_SW.
In your query, set the criteria of the date field as
BETWEEN [FORMS].[nameofform].[begindate] AND [FORMS].[nameofform]...Leave a comment:
-
Are your dates correct? Wouldn't four months old be September 2015?Leave a comment:
-
Memo fields will not show. To get around this, I use LEFT (field,so many characters) for memo fields.
Hope this helpsLeave a comment:
-
Table showing number or records in each report for each day
I'm using access 2010
I need a table that will show the report name, number of records and the date processed. Some of the reports are daily, weekly, monthly, quarterly, etc.
I can add a field to the report to obtain the number of records using count(field).
How do I populate the table for each report...there are at least 15 reports a day and some do may not have records every day.
Will use a date range...
No activity results to display
Show More
Leave a comment: