Adding Autonumber columns into a Query Result

  • Thread starter Thread starter mezzanine1974
  • Start date Start date
M

mezzanine1974

I searched the group message and i found a function below to create a
AutoNumber column for a Query result.

Creating an AutoNumber field from code
http://www.mvps.org/access/tables/tbl0016.htm

I dont know how i can run this code in my Query.

Name of the Query : Q1
Field Name: Quantities

I would like to have additional column named ID which will be produced
by this code.

Can you help me?
 
hi,
I searched the group message and i found a function below to create a
AutoNumber column for a Query result.
Creating an AutoNumber field from code
http://www.mvps.org/access/tables/tbl0016.htm
Click to expand...
You can't use it, cause it is used to create a field in a table.
I dont know how i can run this code in my Query.
Click to expand...
You need a key to order, then you can use this:

SELECT *, (
SELECT Count(*)
FROM QuerySource I
WHERE I.Key < O.Key
) AS ID
FROM QuerySource O
ORDER BY Key

You may use the DCount() function instead of the subselect:

ID: DCount("*";"QuerySource";"Key<" & Key)


mfG
--> stefan <--
 
Back
Top