Append to Table with Auto Number

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I need to paste or use an append query to append a number of rows to a table
that contains an autonumber field. Attempts so far have failed because the
autonumber will not accept a null value.

Any ideas please.

Ta.
Bill.
 
Sorry, I don't think it is the autonumber field that is the issue after all.
its another field that requires a value. Any idea how I populate that with a
default value?

Cheers.
Bill.
 
Bill

In your query, once you've identified which field contains the null(s), use
an IIF() statement to either "keep" the value in the field (if not null) or
use a default (you decide) if the underlying field does contain a null.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append query - Append to table with Autonumber field 2
Append Query To Table 3
Access 2007 - append query only appending 0 rows??? 0
Append to table with 2 fields in Primary Key - last is an autonumb 1
Append Query Issue 0
Append Queries 5
Add data to 2nd table after appending to 1st table 1
Append Query Auto-Number 1

Back
Top