Query to count child entries

[chin chin]

Hi, I'm a beginner trying to get to grips with Access 2007 and can't make the query I need - would really appreciate a some advice.

I need to count up the number of child entries for each record in a parent table. Sounds like it should be easy but I'm struggling badly.

Parent table is called Students, child is called Loans. I need a query that will give Fields [First Name] and [Last Name] from Students, then a 'total number of loans' field that will be a count of the number of records in Loans for each student.

Thanks a lot if anyone has a suggestion.

Chin chin.

 

[vbaInet]

Have a look at this link from Microsoft:

http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx

 

[chin chin]

Have a look at this link from Microsoft:

Great - I managed it from that thanks a lot. I was trying to write the SQL myself and would have never got it right looking at what has been generated.

chin chin

 

[vbaInet]

Glad to know you managed it. That link was gotten by a simple Google search

Good job!

 

[chin chin]

Glad to know you managed it. That link was gotten by a simple Google search

Good job!

Believe me I've been keeping Google busy! Problem was I was looking at the SQL without considering that there might be an automation.

Thanks again.

 

[vbaInet]

It's good to learn the hard way though. I admire your tenacity.

You're welcome!