Query explicit Id

%3CLINGO-SUB%20id%3D%22lingo-sub-2039443%22%20slang%3D%22en-US%22%3EQuery%20explicit%20Id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2039443%22%20slang%3D%22en-US%22%3EHi%2C%20how%20can%20I%20add%20an%20ID%20field%20to%20a%20query%2C%20that%20should%20start%20with%201%20(first%20record)%20and%20end%20with%20last%20record%3F%20It's%20a%20continuous%20number%20field.%3CBR%20%2F%3EMy%20query%20conatains%20two%20fields%3A%20firstname%2C%20productid%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2039443%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2039743%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20explicit%20Id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2039743%22%20slang%3D%22en-US%22%3ETake%20a%20look%20at%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fwww.lebans.com%2Frownumber.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.lebans.com%2Frownumber.htm%3C%2FA%3E%3CBR%20%2F%3Eand%2For%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FGustavBrock%2FVBA.RowNumbers%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FGustavBrock%2FVBA.RowNumbers%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi, how can I add an ID field to a query, that should start with 1 (first record) and end with last record? It's a continuous number field.
My query conatains two fields: firstname, productid
1 Reply