I need help with a Summary Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need help creating a report that contains a summary of records. I need the
report to contain counts of selected fields from different tables. For
example, in one report I need:

Number of interfaces: XXXX (a count of all records in the 'interface' table)
Number of Data Elements: XXX (a count of all records in 'Data Element' table)
Number of Interfaces linked to Data Elements:XXX (a count of records from
'Linked Interface/Data Element' table)

I am a new user of access and this seems to me to be an easy function- I
just have no idea!! Thanks for your help
 
To get a count of all the records in a table into a report, you can
-create a query like SELECT Count(*) as NumRecords FROM tblYourTable
Base your report on this query.
-Base your report on no record source and add a text box with a control
source of
=DCount("*","tblYourTable")
 
Back
Top