Date in query

  • Thread starter Thread starter Michael Hanlon
  • Start date Start date
M

Michael Hanlon

I have a query that draws information from 3 tables. The problem I am having
is that I want my query to only show every user ONCE not multiple times. And
to look at the Course date and find the last course the date the user was on
and entry only that record for each user into the last course completed on.

any and all help welcomed.
 
You must log in or register to reply here.

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

Combine Duplicates in Query 0
dynamic calculated field in query 3
Unmatched query question 3
Filter out records with earlier dates 1
Query Design 1
Query not updatable - advise on how to change it 4
Query Parameters 1
Query to display highest totals 1

Back
Top