I have a database which has records for different locations. I want to run qry for each site - which is easy enough, but I also want to count the number of records and summarise it on a report.
-
-
You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.
MODERATOR. -
You don't share a lot of information with us so it will be difficult to help here. Try posting the MetaData of your relevant tables to give us an idea of what you're working with.
Here is an example of how to post table MetaData :
Table Name=tblStudent
Code:[i]Field; Type; IndexInfo[/i] StudentID; AutoNumber; PK Family; String; FK Name; String University; String; FK Mark; Numeric LastAttendance; Date/Time
Comment
Comment