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
|
|||
|
|||
stupid report problem
I have a very basic question, any suggestions would be
greatly appreciated. I added a text box to the report footer. I want to count the total number of records in the report. I have messed around with the dcount funtion and I am sure I dont have the syntax correct. I am trying to use the dcount function from the control source line in the properties of the text box. I have been able to create a simple query which give me the total, but now I dont know how to call the query from the report. Any suggestions would be great....thanks. bob |
#2
|
|||
|
|||
stupid report problem
wrote:
I have a very basic question, any suggestions would be greatly appreciated. I added a text box to the report footer. I want to count the total number of records in the report. I have messed around with the dcount funtion and I am sure I dont have the syntax correct. I am trying to use the dcount function from the control source line in the properties of the text box. I have been able to create a simple query which give me the total, but now I dont know how to call the query from the report. Rasier to use the expression: =Count(*) -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
stupid report problem
On Tue, 10 Aug 2004 15:08:55 -0700,
wrote: I have a very basic question, any suggestions would be greatly appreciated. I added a text box to the report footer. I want to count the total number of records in the report. I have messed around with the dcount funtion and I am sure I dont have the syntax correct. I am trying to use the dcount function from the control source line in the properties of the text box. I have been able to create a simple query which give me the total, but now I dont know how to call the query from the report. Any suggestions would be great....thanks. bob If all you wish to know is the number of records in the whole report, all you need, in the control source of an Unbound Control anywhere in the Report EXCEPT in the Page Header or Page Footer, is: =Count(*) You can use DCount() referencing a query. The syntax is the same as for a table. =DCount("*","QueryName") or, to limit the count to certain records .... =DCount("*","QueryName","[SomeTextField] = 'New York'") -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Duplicates on a Report (maybe a Query problem too) - Access 2000 | Jeff Boyce | New Users | 2 | July 28th, 2004 01:57 PM |
Report Wizard Problem | vikash | General Discussion | 1 | June 16th, 2004 12:45 PM |
Access 2003 report parameter problem | Peter Kaufman | Setting Up & Running Reports | 0 | June 10th, 2004 01:47 PM |
problem printing report with subquery in recordsource | Jeff B | Setting Up & Running Reports | 2 | May 27th, 2004 02:35 PM |