| Author |
 Topic Search  Topic Options
|
haddadin87 
Newbie
Joined: 29 January 2006
Location: Jordan
Status: Offline
Points: 23
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Reset records in columns
Posted: 06 February 2006 at 12:49am |
I have a columns that i want to reset all it row's to the number 0 instead of other numbers,, i'm using MS ACCESS
can anybody tell me how to do it
thank you very much!
haddadin
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 February 2006 at 3:57am |
|
Update tablename Set ColumnNameWithZeros = 0
just put that in a query and all values will be 0 in that column for every record.
|
|
|
|
haddadin87
Newbie
Joined: 29 January 2006
Location: Jordan
Status: Offline
Points: 23
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 February 2006 at 11:13am |
look i have the columns: Hits, Rating, No of rating, Total rate amount
I want to change the value of these 4 clumns only. to zero "0"
can u give steps please.
Thanks...
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 February 2006 at 2:42pm |
|
Same thing.
Update tablename Set Hits=0,Rating=0,[No of rating]=0,[Total rate amount]=0
GO
|
|
|
|
haddadin87
Newbie
Joined: 29 January 2006
Location: Jordan
Status: Offline
Points: 23
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 February 2006 at 8:26pm |
sorry i couldn't understand this..
can u please give me steps in MS ACCESS PROGRAM how to make it.
sorry for this!
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 February 2006 at 9:12pm |
|
You need to write a query in MS Access. Click on query, new, go to the SQL Screen, paste the code and execute.
|
|
|
|
haddadin87
Newbie
Joined: 29 January 2006
Location: Jordan
Status: Offline
Points: 23
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 February 2006 at 7:23pm |
i think that this is very complicated for a newbie like me :D
is'nt there any way to change the value of a whole column records to 0 just from using the tool bar or menus.
thank you!
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 February 2006 at 9:16pm |
Sure there is, but why easy when it can be hard...
Select the column, press CTRL+H and set as follows:
Click here
|
|
|
|
