By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

access 2002 insert into statement

P: n/a
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;
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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********@yahoo.com> wrote in message
news:39**************************@posting.google.c om...
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;

Nov 12 '05 #2

P: n/a
You need to include OnlineReg2 in the FROM clause of your query.

mc********@yahoo.com (mcca68) wrote in message news:<39**************************@posting.google. 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.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;

Nov 12 '05 #3

P: n/a
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!
Nov 12 '05 #4

P: n/a
Joe Mac <mc********@yahoo.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)
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.