Database Discussion - Reset records in columns

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!