counting records based on 2 criteria

[csharpmin]

I am working on a database for my babysitting company. I would like a count of each time a sitter sitted for a client. Not the number of jobs a sitter has worked on total, mind you, but the number of jobs for each client.

I have included the bare-bones structure I'm working with.

Any help would be greatly appreciated.

Sitters_test.zip

[mr_vodka]

I am assuming you want this in the portal for the Sitters layout instead of in a summary report. Put another table occurence of the Jobs table on the graph. Then create a self join relationship keyed on ClientID. Create a calculation that is a Sum ( Job 2::HoursBooked ) and then you can put this calculation on the portal.

[csharpmin]

Of course, the ol' self-join. Thank you. I used a variation on your tip. I got it working the way I want by making another instance of the Job Table and matching both the sitter and client ids. Then I could count what I wanted.

FYI: I'm using this count so that I can sort a portal of available sitters for a job based on the number of times they've sitted for that client.

Thanks for the help. It was just the inspiration I needed.