Show only most recent record record

V

vp7799

Joined
May 14, 2010
Messages
1
Reaction score
0
Hey all I am working on a database for a tabletop campaign game and I am stuck. I have two table one is "unit" and contains all the information on a unit, types of equipment and etc. the second table is "location". This table holds the locations for all of the units.

Table "unit" contains the following fields
unitid(primary key)
unitname
equipment

Table "location" contains the following fields:
recordnumber (primary key)
unitid
unitdate
unitlocation

the table are joined in a one to many using the unitid field

I want my query to show the most recent locations for all units.

Thanks for any help.
 

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

Query to display all related data from 4-level tree 4
Appending question 6
Another most-recent date query 0
Query help (SQL) 9
probably not as complex as I'm thinking... 8
Adding Record in form - Related Data from related tbl doesn't show 5
Select Only Newest/Most Current date 5
"OR" trouble. 7

Back
Top