Dbase conversion - need help

  • Thread starter Thread starter Shell
  • Start date Start date
S

Shell

How do I do this in Access? Am totally new to Access.

'qty' being a numeric field, I need to subtract one from
whatever numerical number is listed.

In dbase the command would be:
replace all qty with qty-1

it has to do the entire database, not selectively.

tia.
 
Shell,

You would do this with an Update Query. Make a new Query, based on
your table, and add the Qty field to the design grid. Make it an
Update Query by selecting Update from the Query menu. In the Update
To row of the grid, type [Qty]-1 and then run the query by clicking
(once!) the toolbar button with the red ! icon.

- Steve Schapel, Microsoft Access MVP
 
Back
Top