access 2002 insert into statement

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.updated field.

i just wanted to update and/or append new fields when the
"DataTransfer.updated <> OnlineReg2.updated" 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, registrationtype,
[first], [last], email, [password], address, city, country, phone,
region, voluntering, props, years, payment, convention, health,
donation, contact )
SELECT DataTransfer.regDate, DataTransfer.datePaid,
DataTransfer.updated, DataTransfer.tuition, DataTransfer.paidAmount,
DataTransfer.tempID, DataTransfer.iynausId, DataTransfer.paymentType,
DataTransfer.channel, DataTransfer.registrationtype,
DataTransfer.first, DataTransfer.last, DataTransfer.email,
DataTransfer.password, DataTransfer.address, DataTransfer.city,
DataTransfer.country, DataTransfer.phone, DataTransfer.region,
DataTransfer.voluntering, DataTransfer.props, DataTransfer.years,
DataTransfer.payment, DataTransfer.convention, DataTransfer.health,
DataTransfer.donation, DataTransfer.contact
FROM DataTransfer
WHERE DataTransfer.updated <> OnlineReg2.updated;

re: access 2002 insert into statement

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" <mcca68tres@yahoo.com> wrote in message
news:392dd6f5.0401201933.189f32e7@posting.google.c om...[color=blue]
> 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.updated field.
>
> i just wanted to update and/or append new fields when the
> "DataTransfer.updated <> OnlineReg2.updated" 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, registrationtype,
> [first], [last], email, [password], address, city, country, phone,
> region, voluntering, props, years, payment, convention, health,
> donation, contact )
> SELECT DataTransfer.regDate, DataTransfer.datePaid,
> DataTransfer.updated, DataTransfer.tuition, DataTransfer.paidAmount,
> DataTransfer.tempID, DataTransfer.iynausId, DataTransfer.paymentType,
> DataTransfer.channel, DataTransfer.registrationtype,
> DataTransfer.first, DataTransfer.last, DataTransfer.email,
> DataTransfer.password, DataTransfer.address, DataTransfer.city,
> DataTransfer.country, DataTransfer.phone, DataTransfer.region,
> DataTransfer.voluntering, DataTransfer.props, DataTransfer.years,
> DataTransfer.payment, DataTransfer.convention, DataTransfer.health,
> DataTransfer.donation, DataTransfer.contact
> FROM DataTransfer
> WHERE DataTransfer.updated <> OnlineReg2.updated;[/color]

re: access 2002 insert into statement

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

mcca68tres@yahoo.com (mcca68) wrote in message news:<392dd6f5.0401201933.189f32e7@posting.google. com>...[color=blue]
> 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.updated field.
>
> i just wanted to update and/or append new fields when the
> "DataTransfer.updated <> OnlineReg2.updated" 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, registrationtype,
> [first], [last], email, [password], address, city, country, phone,
> region, voluntering, props, years, payment, convention, health,
> donation, contact )
> SELECT DataTransfer.regDate, DataTransfer.datePaid,
> DataTransfer.updated, DataTransfer.tuition, DataTransfer.paidAmount,
> DataTransfer.tempID, DataTransfer.iynausId, DataTransfer.paymentType,
> DataTransfer.channel, DataTransfer.registrationtype,
> DataTransfer.first, DataTransfer.last, DataTransfer.email,
> DataTransfer.password, DataTransfer.address, DataTransfer.city,
> DataTransfer.country, DataTransfer.phone, DataTransfer.region,
> DataTransfer.voluntering, DataTransfer.props, DataTransfer.years,
> DataTransfer.payment, DataTransfer.convention, DataTransfer.health,
> DataTransfer.donation, DataTransfer.contact
> FROM DataTransfer
> WHERE DataTransfer.updated <> OnlineReg2.updated;[/color]

re: access 2002 insert into statement

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!

re: access 2002 insert into statement

Joe Mac <mcca68tres@yahoo.com> wrote in news:400e7550$0$70307$75868355
@news.frii.net:
[color=blue]
> Sorry about being vague. It was executed from the query. Thanks :)[/color]

That helps a lot.

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