Ok, to clarify further...we are trying to create a new Table from a Query that will automatically include an Autonumbered field to uniquely identify each resulting record that is displayed from the Query. (does that help..?) JAH
Why? This has almost no useful purpose ... With querying you can iterate thru the rec
I also have the same problem to uniquely identify each record from the query. What my query does is it picks up the top 5 records from a table based on certain condition. Now I want to display this 5 records simultaneously on a report, with each record field being displayed in a seperate text field i.e. Record 1 field 1 in text box 1, Record 1 field 2 in text box 2, ..........., Record n field m+n text box y. Without a unique number on the query it will be very difficult to pick up the required records, I mean how to tell Access to go and pick up first record, then second record, etc? With autonumber in the query, it would be easier to extract the required information record by record from the query. Any suggestions plz?
And M Owen, could you plz explain in detail about your previous anwer....
"With querying you can iterate thru the recordset and have an external counter for "uniquely identifying" each record ".