Editing players.dbf on MS Access 2002

[Heavenly]

I know my way around with Access but theres something i dont know.


How can i edit a line for all records??? for example, reduce offensive rebounds for all players by 25%.

[shadowgrin]

Make a formula like in Excel?

[A.G.]

Create a querry, then choose an update querry. After that you can edit every column like adding or substracting 10 %. Just find the correct syntax in help.

Hope that helps.

[ngkwokfai]

Hi, first post here. You can open players.dbf with access, go to queries, create new query in design view, close the window. switch to sql view (click on the SQL button on the toolbar), enter the follow and hit run (! icon)

UPDATE Players SET OREABILITY = OREABILITY/2

This will reduce all the ratings by half.

If you want to subtract by an amount instead of using percentage, use:

UPDATE Players SET OREABILITY = OREABILITY-30
UPDATE Players SET OREABILITY = 1 WHERE OREABILITY < 1

The second line is used to make all the negatives into 1.