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

Update query?

P: n/a
I am in the process of building an application that lists several orders
on one table with various info to some other tables with other info
relating to these orders and access this via .asp. I receive updates to
some of these tables from our AS/400 in the form of comma separated text
files and the updates work fine. We now want to add a field to one of
the tables that will say when an invoice has been paid, a simple y or n
or whatever. What I can't seem to figure out is how to do this. I simply
want to add this y to a field that was left blank on the table when it
was initially entered, according to the the order numbers. The imported
file would have 3 columns, one listing order number one listing invoice
number and one with a y in it. Each of the invoice numbers would be
unique so they should have no problem matching these up to what is
already in there. I have searched for an answer and it seems to be "use
an update query" I have a book here and I still am lost as to how to
accomplish this. Can anyone make any suggestions or can you point me to
a downloadable database that does something like this so I can take a
look at it and figure it out?

Thanks,
Travis

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The invoice has been paid when the payments are equal to (or greater) than
the invoice amount. Why do you need a y/n field?

Robert Crouser

"Travis" <no**@nowhere.com> wrote in message
news:9E*****************@news7.onvoy.net...
I am in the process of building an application that lists several orders
on one table with various info to some other tables with other info
relating to these orders and access this via .asp. I receive updates to
some of these tables from our AS/400 in the form of comma separated text
files and the updates work fine. We now want to add a field to one of
the tables that will say when an invoice has been paid, a simple y or n
or whatever. What I can't seem to figure out is how to do this. I simply
want to add this y to a field that was left blank on the table when it
was initially entered, according to the the order numbers. The imported
file would have 3 columns, one listing order number one listing invoice
number and one with a y in it. Each of the invoice numbers would be
unique so they should have no problem matching these up to what is
already in there. I have searched for an answer and it seems to be "use
an update query" I have a book here and I still am lost as to how to
accomplish this. Can anyone make any suggestions or can you point me to
a downloadable database that does something like this so I can take a
look at it and figure it out?

Thanks,
Travis

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.