possible to add a "record number" to a query?

I would like to have a column returned in a query that tells you which record I'm looking at? Sort of like an auto_increment? IOW, the query results would look like: record first last 1 john doe 2 joe blow 3 carol fisher The table only has first and last, but I want the results to add something like record to tell me which record it is. Thanks for any help! Jeff