If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a printed report containing multiple counts
Hi All,
Been trawling around for a solution to this problem. The problem is pretty straightforward, yet surprisingly complicated to solve. I have a statistical report that needs creating when demanded by the user. The user enters a date range on the form in 2 text boxes and the values are passed into queries(?). The stats report should then contain a load of count statistics for how many records have been received/rejected/exported etc. in that date range. The counts also have different conditions - imported records for instance need to fit the date range entered by the user, but for the exported records section of the report, records' export date needs to fit the date range specified. 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? Thanks in advance to anyone that helps! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201005/1 |
Thread Tools | |
Display Modes | |
|
|