Query design

S

sabhoir

Joined
Sep 16, 2021
Messages
1
Reaction score
0
I am trying to make a simple access utility to track calibration satus.
I have a tblstatus table with the fields statusID, EquipmentID, DateCalibrated, Status with a linked table tblEquipment.
I would like the report to display only the current record on DateCalibrated.
How do I go about.
 

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

Database Design 4
SQL query with join on substring 5
Can't create a report from my query in Access 1
Query with unrelated tables 7
Textbox control source problem 10
Another most-recent date query 0
Show Records From Table1 That Aren't in Table2... 5
Access stripping decimal places in query 1

Top