Autonumber Question

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Can append or update a query with an autonumber field???

I have a table of names that I need to be referenced as a
letter in the report???

Any help would b e great.

Tom
 
Can append or update a query with an autonumber field???

I have a table of names that I need to be referenced as a
letter in the report???
Click to expand...

Yes.

If you have the (auto)numbers to add, then put them in the field list: if
you omit them then Jet will allocate them as normal:-

INSERT INTO MyTable (MyAutoNumberField, MyNameField)
SELECT ExternalNumber, ExternalName
FROM MyExternalTable
WHERE ToBeImported = TRUE;


or

INSERT INTO MyTable (MyNameField)
SELECT ExternalName
FROM MyExternalTable
WHERE ToBeImported = TRUE;

Hope that helps


Tim F
 
Back
Top