Total records printed

[LesleyA]

I have this table full of names, DOBs, etc. On the screen, it gives me the total amount of records in the window. I would like that number to print out when I print my table or queries.



I've looked in a few Access books and been all over the web with no success.

Can anyone help me? Please!

[jya]

I am not sure I understand what you mean by total amount of records in the window. If you want the total number of records, I imagine that you could print a report with its record source being your table or query and placing a text box in the footer with a Dcount as the control source. Otherwise, I probably don't know.

[LesleyA]

I have a table of 345 individuals with their information. I would like "Total records 345" print out after the table. The footer would be a good option, but how do I go about being able to modify the footer and add a DCount formula.

[Ahmed Elalfy]

Dear LesleyA,

You have database contains a table
This table contains records of 345 individuals
You need to print these records and show "Total records 345" at the end
Is that what you mean??

If Yes
You have to create a report using the following steps:
From insert menu choose report
Select report wizard
From report wizard window select your table/query
Choose your field you want to show in the report
Press next
If you need to group the records (for example: if the records belong to emplyees you can group them by department, by position, by locatione or by supervisor ...)
Double click on the field that you want to group the records with
You can make several levels of groups
Press next
Select the field that you want to order with
Press next
Change the view of the report as you want
Press finish

The output report by default contains the date / time / pages in the footer
if you want to customize the view press design view

To add the no of records at the end of the report
Inster textbox from toolbox bar

Write "Total records " in the lable of the textbox
Right click on the textbox ... select properties
In data tab write the following:

=Count([ID])

Where ID is the name of any mandatory field in the table...

I hope the above data to be usefull for you

Please feedback

Thanks

Ahmed