I'm trying to show the number of records in a query in a report -Can anyone help me?
M Mickey Dec 23, 2003 #1 I'm trying to show the number of records in a query in a report -Can anyone help me?
D Duane Hookom Dec 23, 2003 #2 Add a text box to the report header or footer with a control source of =Count(*)
M Mickey Dec 23, 2003 #3 Thank you! now, can I show that (the total # of records) from several different queries in one report? Thanks in advance Mickey
Thank you! now, can I show that (the total # of records) from several different queries in one report? Thanks in advance Mickey
D Duane Hookom Dec 23, 2003 #4 A report can have only one recordsource/query. You can use subreport that are bound to their own query. Another method is to use a text box bound to the control source of: =DCount("*","tblYourTable")
A report can have only one recordsource/query. You can use subreport that are bound to their own query. Another method is to use a text box bound to the control source of: =DCount("*","tblYourTable")
