Displaying Last Record of a Query

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have run a query from a table, pulling 5 of the 10
fields of information. What I would like to do is have
the query only display the last record of however many
entries there are. How would I go about doing this?

Reason I am displaying last record is so I can do a
columnar report to print to an rtf file so I can copy /
paste data into an excel document / as400. If anyone has
any ideas on a better way to do this, please tell me!!

Thanks!
 
Dave

Define "last". What you think of as last, and what Access considers last
may not match up. If you mean "the most recently-entered row", how does
Access know which one you mean? Do you also record a date/time?

If you want to export data to Excel, you can build a query and use
File/Export to send it (or one of the TransferX() functions).

Good luck

Jeff Boyce
<Access MVP>
 
Thanks for the response!

What I mean by last is by ID number. ID number is my
primary key and increases positively by 1 each record...so
if there are 100 records, and id is 180 (meaning I deleted
80 records), then I want it to show id 180 (or the 100th
record). Access sees the last record as being the last ID
number, I would assume.

Also, exporting to an excell file shows the column's
horizontally when I would like to show them vertically,
and is the reason why I am having such troubles.

Any ideas?

Thanks!
 
Back
Top