Access 2016 Queries

J

JTZ

Joined
Jan 21, 2016
Messages
2
Reaction score
0
Hi,
I am using MS Access 2016 to create a table keeping records of Students tests results.
The table consists of 6 columns (name, test1 .... test5)
Using a simple query to find who got 2 specific marks, e.g. 15 or 31.
Now I want to shortlist the query and show only the student/s who got both marks, i.e. 15 and 31
How can I do this?
Thanks JTZ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2016 Queries 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Calculating Meal Period Violations in Access 2
count formula 1
Query in VBA 1
Combine queries 2
Combine queries 13
Problem editing a query based on another query and table 3

Top