Simply Query - Return only first record??

[ktariske]

Hi, I run a query, and I only want to return the first record, not the entire record set to a report. Can I somehow limit it to just the first record?

 

[dcx693]

Do you care which record becomes the first record? The first one entered? The last one entered? The largest value? Smallest value? Lowest ID number?

You can run a TOP values query and just specify 1. When editing your query, go to the View menu, choose Properties. That should bring up the query property sheet. (Make sure not to click on a field after that, because that will change the property sheet to displaying field properties. If so, just click on the query background.) In the Top Values entry, type in 1. Then run your query. You should sort your records else you might just wind up with a random "top" choice.

 

[dcx693]

You can also run totals query (in query design view, choose View, Totals) and choose Max, Min, First, or Last in the Total line.