Add autonumber field in query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi ppls,

Maybe it's an easy question, so don't shoot me.
I want to do following thing:

I want to make a query in which I load (calculate) some fields (on which i
do calculations). No problem for that. Now it comes. I want also a create a
field that doesn't exist, namely a Autonumber field (ID). Why?

--> i've got two tables with data. First table is the reference table and
second is reference table that is updated after some calculations (new
numbers are added and so on). I want to compare the positions of people in
such way that i can say, you've gained positions or lost positions with
when we compare the reference table and new table (by comparing the ID's in
the two tables).

So conclusion:

OR i need to find out how i can add a field in the query that makes
automatic an ID (autonumber the list that is the result of the query) so
that i can test the position in another to make query.

OR you guys know a better solution for my problem.


Thanx in advance,

Freshke
.

Relevant Pages

  • Re: Add autonumber field in query
    ... Before running the query I set the fakeAutoNumber to zero, ... namely a Autonumber field. ... I want to compare the positions of people in such way that i can say, you've gained positions or lost positions with when we compare the reference table and new table. ...
    (microsoft.public.access.queries)
  • Re: Add autonumber field in query
    ... > I want to make a query in which I load some fields (on which i ... namely a Autonumber field. ... > when we compare the reference table and new table (by comparing the ID's ...
    (microsoft.public.access.queries)
  • Re: relating two tables with common field but not seeing data in forms.
    ... >this should bring up the query design grid with your two tables shown. ... >database table when you get a new csv file. ... >> member datafields to each record. ... >> example, to keep it simple, one reference number field and name field. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Table data being deleted in query, help
    ... It probably is the query, ... > in the description fields from all the various reference tables that will be ... >>> ExpenseElement and UserID and ReportHdr. ... >>> to datasheet view, you can not delete a record) ...
    (microsoft.public.access.formscoding)
  • Re: Table data being deleted in query, help
    ... The query has the main table and those ... and delete records without affecting the sources from the reference tables. ... > integrity not checked, ... nor is the cascading deletes or edits checked. ...
    (microsoft.public.access.formscoding)