Editing players.dbf on MS Access 2002
Sun Oct 30, 2005 11:36 pm
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%.
How can i edit a line for all records??? for example, reduce offensive rebounds for all players by 25%.
Huh?
Mon Oct 31, 2005 10:27 am
Make a formula like in Excel?
Tue Nov 01, 2005 3:50 am
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.
Hope that helps.
Tue Nov 01, 2005 2:05 pm
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.
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.