Autonumber Question

[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

 

[Tim Ferguson]

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???

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