hogdriver53
Registered User.
- Local time
- Yesterday, 20:27
- Joined
- Jan 1, 2020
- Messages
- 21
[SOLVED]Collecting statisctics in db with VBA
Hi all,
I have another question about the db I'm working on.
This time, it's about collecting and displaying statistics.
I would like to collect several stats (off of a query page?) and have them displayed on a form. And it's all based on two dates - start date and end date - kind of like monthly stats.
Right now, on my Stats page, when I enter the start date and end date, and click the 'Results' button, a report pops up and shows the number of containers examined within the date range selected.
How can I have the stats displayed on a form - the number of containers examined, the type of exams, what terminals, container type, etc....
I tried several ways to use the DCount() function, but am getting nowhere.
Any suggestions would be greatly appreciated. Attached is my sample db.
On the stats page, if you enter Jan.1/20 and Jan. 4/20 as start and end dates, it will display 4 containers on a popup report. It's that info I would like to show it on the stats page.
Thanks, Andrew
Hi all,
I have another question about the db I'm working on.
This time, it's about collecting and displaying statistics.
I would like to collect several stats (off of a query page?) and have them displayed on a form. And it's all based on two dates - start date and end date - kind of like monthly stats.
Right now, on my Stats page, when I enter the start date and end date, and click the 'Results' button, a report pops up and shows the number of containers examined within the date range selected.
How can I have the stats displayed on a form - the number of containers examined, the type of exams, what terminals, container type, etc....
I tried several ways to use the DCount() function, but am getting nowhere.
Any suggestions would be greatly appreciated. Attached is my sample db.
On the stats page, if you enter Jan.1/20 and Jan. 4/20 as start and end dates, it will display 4 containers on a popup report. It's that info I would like to show it on the stats page.
Thanks, Andrew
Attachments
Last edited: