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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Divyash 
×
×
  • Create New...

Important Information

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