Temporary ID#

  • Thread starter Thread starter Andy6
  • Start date Start date
A

Andy6

I have a table of Products with fields ID, ProdCode, Description, Available,
etc.
I need to run a query on this table and exclude all products with 'No' in
the field [Available] leaving a record set of all available products, easy
enough.
Question:
Is it possible to add a new field within this query that would give me a
TempID numbering the records from 1 to MaxNo of records?
Sounds simple but I'm scratching my head.
Many thanks in advance for any assistance.
Andy.
 
Thank you Tedmi for your suggestion, I had already followed it after reading
the response to the question directly above mine and this led me also to the
Lebans site ( very helpfull) and then on to the Microsoft help at
http://msdn.microsoft.com/en-us/library/bb221121.aspx and the
AbsolutePosition keyword and I'm working from there to resolve my particular
problem. But thankyou for your quick response.
Andy

tedmi said:
See http://allenbrowne.com/ranking.html
--
TedMi

Andy6 said:
I have a table of Products with fields ID, ProdCode, Description, Available,
etc.
I need to run a query on this table and exclude all products with 'No' in
the field [Available] leaving a record set of all available products, easy
enough.
Question:
Is it possible to add a new field within this query that would give me a
TempID numbering the records from 1 to MaxNo of records?
Sounds simple but I'm scratching my head.
Many thanks in advance for any assistance.
Andy.
Click to expand...
Click to expand...
 
Back
Top