Help With Append Query (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

Topic

New Reply

I have a table with the following records

Specialty ID	Specialty
1	Optometrist
2	Children's Dentist
3	General Dentistry
4	New Dentist 
5	Orthodontics 

I’m trying to add one record to the table with this append query

INSERT INTO tblSpecialties ( strSpecialty )
SELECT "NA" AS Expr1
FROM tblSpecialties;

And I am getting the following 5 records

Specialty ID	Specialty
6	NA
7	NA
8	NA
9	NA
10	NA

Specialty ID is a autonumber

What do i have the change to just get the one record
6 NA

Thanks, John

Reply | Quote

Replies

Because of the SELECT … FROM …, you’ll add as many records as there already were
INSERT INTO has another form where you add a single record:

INSERT INTO tblSpecialties ( strSpecialty )
VALUES ( “NA” )

Reply | Quote

Woops!

Thank you for that

John

Reply | Quote