Jump to content
Sign in to follow this  
csharpmin

counting records based on 2 criteria

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.