I would like to add a "counter ID" to a set of grouped data within a query. For example, if I have 5 records, 2 with a value of A and 3 with a value of B, I would like to see the following results:
a 1
a 2
b 1
b 2
b 3
Can anyone help?
User Profile
Collapse
-
Adding counter ID to set of data within group
-
Appending data to .txt file from Query
Does anyone know how to append data from a MS Access query to a .txt file. I have a process to import data and check for errors. I would like to report the errors to a text file after every import without deleting the previous results (ie the Transfer text method)
Thanks -
how to append query result from ms access to .txt file
Does anyone know how to append data from a MS Access query to a .txt file. I have a process to import data and check for errors. I would like to report the errors to a text file after every import without deleting the previous results (ie the Transfer text method)
Thanks
No activity results to display
Show More