
Query Build and Design
- or -
Post a project like this2789
$
- Posted:
- Proposals: 3
- Remote
- #2004702
- Awarded
Description
Experience Level: Entry
I know just enough to be completely dangerous with Access. I have two tables and need to be able to build a query to get certain reports or information from those tables.
I need to be able to type in a tournament name, It pulls all names who are currently in that tournament, and give me total count of how many times they have played in other tournaments and a list of those tournaments for anyone > 1
So for example... it should return Diane Stone, because she has played in 5 tournaments, and it should give me the number 5 for her total, and list out the 5 tournament names she did play. So for Hilton Head 2018.... it should return 14 names that have more than 1 tournament played and next to those names it should list out all the tournaments they have played in the past, plus the total number as well
I need to be able to type in a tournament name, It pulls all names who are currently in that tournament, and give me total count of how many times they have played in other tournaments and a list of those tournaments for anyone > 1
So for example... it should return Diane Stone, because she has played in 5 tournaments, and it should give me the number 5 for her total, and list out the 5 tournament names she did play. So for Hilton Head 2018.... it should return 14 names that have more than 1 tournament played and next to those names it should list out all the tournaments they have played in the past, plus the total number as well
Oakley F.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
67%
Last project
25 May 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies