Solved

Update All Records

Posted on 2011-09-18
2
260 Views
Last Modified: 2012-05-12
Hi,

I have one table:

Name - Text
Location - Text
Ddate - Date/Time (Medium Date)
Day - Text

The sad part is there is no primary/autonumber in the table.

Situation is something, this database is like 2 years old and the data is being regularly updated. The day column has been recently inserted. Now what we want is to update all the day to weekday names according to the Ddate.

How can I do it?
0
Comment
Question by:Rahul Sehrawat
2 Comments
 
LVL 10

Accepted Solution

by:
plummet earned 500 total points
ID: 36556833
Try this:

1) Backup your database
2) Create a new query
3) In the SQL view enter this (but replace yourtablename):
       Update yourtablename set [Day]=format(Ddate,"dddd")

Running the query should populate the Day field with the day name.

I hope that's what you want, let me know how you get on.
0
 

Author Closing Comment

by:Rahul Sehrawat
ID: 36556841
Worked. :)
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now