Insert query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two tables. CUSTOMER and ERR

I would like to design an INSERT INTO query that inserts
into the table ERR the value "2003-2004" and the customerID into the two
relavant fields of the table ERR for a particular recordset (Ie a recordset
that is created by a select query with a where clause).

For example (in pseudocode):

INSERT INTO ERR
'2003-2004', CUSTOMER.ID

for the recordset
SELECT CUSTOMER.ID, CUSTOMER.STATE from CUSTOMER WHERE CUSTOMER.STATE = "NSW"

Note: The value '2003-2004' is not in the customer table. It is just a
static value that I want to insert in the table ERR for all the relevant
recordset. Also, the customer ID obviously relates to the relevant record in
the recordset created.

One more thing, the table ERR has more than just two fields, does this
matter?

Thnaks for any assistance.

I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia
 
I forgot to mention that Staticfield and ID should be fieldnames which exist
in the table ERR

- Raoul
 
Hi, Try this

INSERT INTO Err (StaticField, ID)
SELECT "2003-2004", Customer.ID FROM Customer WHERE Customer.State="NSW"


- Raoul
 
Hi,


Have you tried:



INSERT INTO err(field1, field2)
SELECT '2003-2004', id FROM customers WHERE state= "NSW"





Hoping it may help,
Vanderghast, Access MVP
 
Back
Top