By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Getting individual information from the last record of a query

P: n/a
If I have a query that returns say, 3 records sorted by date, so that the
latest record is at the bottom of the list, can I then use just the
information from that last record to put onto an external report? The
problem is that I actually need to send the information out to a Microsoft
Word merge document and simple things that you can use subreports for within
Access and therefore have access to more than one query, have to all be
"gettable" from the one query that I use to send the merge data out to the
merge document. Does anyone have any idea for a simple solution for this?

dixie
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
TC
If you want the last record when sorted by field XYZ, try the query:

SELECT TOP 1 * FROM whatever ORDER BY XYZ DESC

HTH,
TC
"dixie" <di****@dogmail.com> wrote in message
news:Mb***************@nnrp1.ozemail.com.au...
If I have a query that returns say, 3 records sorted by date, so that the
latest record is at the bottom of the list, can I then use just the
information from that last record to put onto an external report? The
problem is that I actually need to send the information out to a Microsoft
Word merge document and simple things that you can use subreports for within Access and therefore have access to more than one query, have to all be
"gettable" from the one query that I use to send the merge data out to the
merge document. Does anyone have any idea for a simple solution for this?

dixie

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.