Print Page | Close Window

Reset records in columns

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18276
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Reset records in columns
Posted By: haddadin87
Subject: Reset records in columns
Date 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



Replies:
Posted By: michael
Date 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.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: haddadin87
Date 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...


Posted By: michael
Date 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

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: haddadin87
Date 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!
 


Posted By: michael
Date 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.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: haddadin87
Date 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!
 


Posted By: michael
Date 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:
http://mbgaleria.com/photos/screenshots/images/298/original.aspx - Click here

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: haddadin87
Date Posted: 08 February 2006 at 10:57pm
thanks you are the greatest mod!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net