Update query?

[Travis]

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

[Robert Crouser]

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