|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Total number of records in a table included in a report
I'm sure this is a very basic and obvious question, still, I can not seem to get Access to do quite what I need. Very simple: A report is generated from a single table. I would like to show at the top of this report, the total number of records in the table. AutoNumber is not an option, as records are added and removed. I have a query that generates this very number I need, but can not seem to include it in the report.
|
|
#2
|
|||
|
|||
|
Try 'myTable.Count' in the report header (no quotes).
Later, David Somers |
|
#3
|
|||
|
|||
|
Quote:
The problem is, when I do this, when opening the report, a input windo pops up that requests "Enter Parameter Value". |
|
#4
|
|||
|
|||
|
How are you trying to include your query in the report?
S- |
|
#5
|
|||
|
|||
|
Quote:
I open the report in Design Mode, and add a text box. Under Properties, as the control source, I select the query. |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Total number of records in a table included in a report |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|