Update query question

  • Thread starter Thread starter KHogwood-Thompson
  • Start date Start date
K

KHogwood-Thompson

Hi All,

I have a table containing customer transactions, the following fields are in
the table:

CUSTREF, CUSTNAME, OURREF, DATE, TOTAL, DUE

For certain records that have OURREF = "CHQ", I want to update the DUE
column to equal the TOTAL column for that record.

How can I achieve this?
 
Create a new query in design view based on your table. Insert the fields
OURREF and DUE into the query grid. Put criteria of "CHQ" in the OURREF
column. Right click in the top half of the query designer and select Query
Type - Update query. In the 'update to' row of your DUE column put [TOTAL]
 
Thats perfect, thanks very much!
--
K Hogwood-Thompson


RonaldoOneNil said:
Create a new query in design view based on your table. Insert the fields
OURREF and DUE into the query grid. Put criteria of "CHQ" in the OURREF
column. Right click in the top half of the query designer and select Query
Type - Update query. In the 'update to' row of your DUE column put [TOTAL]

KHogwood-Thompson said:
Hi All,

I have a table containing customer transactions, the following fields are in
the table:

CUSTREF, CUSTNAME, OURREF, DATE, TOTAL, DUE

For certain records that have OURREF = "CHQ", I want to update the DUE
column to equal the TOTAL column for that record.

How can I achieve this?
Click to expand...
Click to expand...
 
Back
Top