access 2002 insert into statement

[mcca68]

hi

i'm trying to insert new and updated fields into my onlinereg2 table
from datatransfer table (imported weekly into access), though i am
running into problems. when i click run, i receive an input box
"enter parameter value" of onlinereg2.upda ted field.

i just wanted to update and/or append new fields when the
"DataTransfer.u pdated <> OnlineReg2.upda ted" are not equal to one
another because the only way of knowing if any one field has been
modified, the updated field is changed from the old updated date to
the date when modified.

so if anyone knows why my insert into statement is not working, any
advice would be appreciated.

thanks!!

INSERT INTO OnlineReg2 ( regDate, datePaid, updated, tuition,
paidAmount, tempID, iynausId, paymentType, channel, registrationtyp e,
[first], [last], email, [password], address, city, country, phone,
region, voluntering, props, years, payment, convention, health,
donation, contact )
SELECT DataTransfer.re gDate, DataTransfer.da tePaid,
DataTransfer.up dated, DataTransfer.tu ition, DataTransfer.pa idAmount,
DataTransfer.te mpID, DataTransfer.iy nausId, DataTransfer.pa ymentType,
DataTransfer.ch annel, DataTransfer.re gistrationtype,
DataTransfer.fi rst, DataTransfer.la st, DataTransfer.em ail,
DataTransfer.pa ssword, DataTransfer.ad dress, DataTransfer.ci ty,
DataTransfer.co untry, DataTransfer.ph one, DataTransfer.re gion,
DataTransfer.vo luntering, DataTransfer.pr ops, DataTransfer.ye ars,
DataTransfer.pa yment, DataTransfer.co nvention, DataTransfer.he alth,
DataTransfer.do nation, DataTransfer.co ntact
FROM DataTransfer
WHERE DataTransfer.up dated <> OnlineReg2.upda ted;

[Larry Linson]

We might be able to make a much better guess if we didn't first have to
guess at the composition of the Insert (more than likely, not a statement,
but an SQL view of a Query?) and from where, and how it was executed.
Clarify, remembering that the questions most likely to get a good answer are
"precise and concise".

Larry Linson
Microsoft Access MVP
"mcca68" <mc********@yah oo.com> wrote in message
news:39******** *************** ***@posting.goo gle.com...

hi

i'm trying to insert new and updated fields into my onlinereg2 table
from datatransfer table (imported weekly into access), though i am
running into problems. when i click run, i receive an input box
"enter parameter value" of onlinereg2.upda ted field.

i just wanted to update and/or append new fields when the
"DataTransfer.u pdated <> OnlineReg2.upda ted" are not equal to one
another because the only way of knowing if any one field has been
modified, the updated field is changed from the old updated date to
the date when modified.

so if anyone knows why my insert into statement is not working, any
advice would be appreciated.

thanks!!

INSERT INTO OnlineReg2 ( regDate, datePaid, updated, tuition,
paidAmount, tempID, iynausId, paymentType, channel, registrationtyp e,
[first], [last], email, [password], address, city, country, phone,
region, voluntering, props, years, payment, convention, health,
donation, contact )
SELECT DataTransfer.re gDate, DataTransfer.da tePaid,
DataTransfer.up dated, DataTransfer.tu ition, DataTransfer.pa idAmount,
DataTransfer.te mpID, DataTransfer.iy nausId, DataTransfer.pa ymentType,
DataTransfer.ch annel, DataTransfer.re gistrationtype,
DataTransfer.fi rst, DataTransfer.la st, DataTransfer.em ail,
DataTransfer.pa ssword, DataTransfer.ad dress, DataTransfer.ci ty,
DataTransfer.co untry, DataTransfer.ph one, DataTransfer.re gion,
DataTransfer.vo luntering, DataTransfer.pr ops, DataTransfer.ye ars,
DataTransfer.pa yment, DataTransfer.co nvention, DataTransfer.he alth,
DataTransfer.do nation, DataTransfer.co ntact
FROM DataTransfer
WHERE DataTransfer.up dated <> OnlineReg2.upda ted;

[Jeff Colton]

You need to include OnlineReg2 in the FROM clause of your query.

mc********@yaho o.com (mcca68) wrote in message news:<39******* *************** ****@posting.go ogle.com>...

hi

i'm trying to insert new and updated fields into my onlinereg2 table
from datatransfer table (imported weekly into access), though i am
running into problems. when i click run, i receive an input box
"enter parameter value" of onlinereg2.upda ted field.

i just wanted to update and/or append new fields when the
"DataTransfer.u pdated <> OnlineReg2.upda ted" are not equal to one
another because the only way of knowing if any one field has been
modified, the updated field is changed from the old updated date to
the date when modified.

so if anyone knows why my insert into statement is not working, any
advice would be appreciated.

thanks!!

INSERT INTO OnlineReg2 ( regDate, datePaid, updated, tuition,
paidAmount, tempID, iynausId, paymentType, channel, registrationtyp e,
[first], [last], email, [password], address, city, country, phone,
region, voluntering, props, years, payment, convention, health,
donation, contact )
SELECT DataTransfer.re gDate, DataTransfer.da tePaid,
DataTransfer.up dated, DataTransfer.tu ition, DataTransfer.pa idAmount,
DataTransfer.te mpID, DataTransfer.iy nausId, DataTransfer.pa ymentType,
DataTransfer.ch annel, DataTransfer.re gistrationtype,
DataTransfer.fi rst, DataTransfer.la st, DataTransfer.em ail,
DataTransfer.pa ssword, DataTransfer.ad dress, DataTransfer.ci ty,
DataTransfer.co untry, DataTransfer.ph one, DataTransfer.re gion,
DataTransfer.vo luntering, DataTransfer.pr ops, DataTransfer.ye ars,
DataTransfer.pa yment, DataTransfer.co nvention, DataTransfer.he alth,
DataTransfer.do nation, DataTransfer.co ntact
FROM DataTransfer
WHERE DataTransfer.up dated <> OnlineReg2.upda ted;

[Joe Mac]

Sorry about being vague. It was executed from the query. Thanks :)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lyle Fairfield]

Joe Mac <mc********@yah oo.com> wrote in news:400e7550$0 $70307$75868355
@news.frii.net:

Sorry about being vague. It was executed from the query. Thanks :)

That helps a lot.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)