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 derfloh 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
Joined
Sep 4, 2001
Messages
122
Location
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

telephoto
  • Locked
  • Question Question
Report waiting for printer before displaying results
Replies
3
Views
653
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
Print multiple copies of report data
Replies
5
Views
1K
dhookom
dhookom
breezett93
  • Locked
  • Question Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
1K
dhookom
dhookom
renigar
  • Locked
  • Question Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
5K
renigar
renigar
JimStrand
  • Locked
  • Question Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top