Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Only report last record of two linked tables

Status
Not open for further replies.
njitter

njitter

Technical User
Sep 4, 2001
122
US
I have the following linked tables:

guidancexw9.png


I would like to display only the latest record in the Detailed Info table together with the Guidelines information (record with the newest Entry Date)

How to get this record?

---
Happy Happy Joy Joy
 
Sort by date Sort by votes
Join your tblGuidelines with this query rather than the detail info table.
Code: 
SELECT *
FROM tblDetailInfo
WHERE [Guidance_ID] = 
 (SELECT Guidance_ID
  FROM tblDetailInfo d
  WHERE d.ID = tblDetailInfo.ID
  ORDER BY Entry_Date DESC)

Duane MS Access MVP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
260
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
270
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
547
renigar
renigar
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
255
dhookom
dhookom
breezett93
  • Locked
  • Question
Sending report via email only works when Outlook is closed
Replies
1
Views
210
breezett93
breezett93

Part and Inventory Search

Sponsor

Back
Top