Counting how many records where pulled up

[chellebell1689]

Hello, I have a form that filters my records and then sends everything over to a report (which is basically the form, but just shows the filtered records). How do I count how many records where pulled up on the report? I know it's possible if you base the report on a query, but that's not the case here.

Thank you in advance for your help.

 

[jdraw]

Your "form/report" will have a record source.
Look at the design view - data and see what it lists as the record source.
Also check the Filter you are using.
Post back what values you find.

 

[chellebell1689]

The source for both the form and the report are "queried" from two tables (one to pull up the date, name and attended class; the other to pull up the name of the class and the teacher).
As for the filters, they are just the date and class.

 

[jdraw]

Show the SQL for the record source.

 

[chellebell1689]

SELECT SSAttendance.StudentFName, SSAttendance.StudentLName, SSAttendance.AssignedClass, SSAttendance.InAttendance, SSAttendance.DateofAttendance, SSAttendance.ClassAttended, SSClass.SSClass, SSClass.SSTeacher, SSClass.SSAbrev
FROM SSClass INNER JOIN SSAttendance ON SSClass.ClassID = SSAttendance.AssignedClass;


That's for the form. I just realized there's a better way to do the report, create a report based on this form (which is not how I had that set up).

 

[jdraw]

In the query design grid you could try pasting the following SQL (untested)

Select count(*) FROM
(
SELECT SSAttendance.StudentFName, SSAttendance.StudentLName, SSAttendance.AssignedClass, SSAttendance.InAttendance, SSAttendance.DateofAttendance, SSAttendance.ClassAttended, SSClass.SSClass, SSClass.SSTeacher, SSClass.SSAbrev
FROM SSClass INNER JOIN SSAttendance ON SSClass.ClassID = SSAttendance.AssignedClass
);

 

[chellebell1689]

It's working! Thank you!