entering date in access records

H

Hanamachi

hello everyone,

I have this following problem. I have a access database with thousands
of records. The problem now is I want to enter the same date into all those
records, how can I do it in one shot?

thanks,
 
K

Kevin B

Create a new query using the table that needs to be updated. From the query
grid, click QUERY in the menu and select UPDATE QUERY

In the query grid, select the date field as the field to update as the first
colum and in teh UPDATE TO row in the current column set the update value to
Now()

Since you're updating all records, no criteria is necessary. Click the run
button on the toolbar and confirm the update when asked.
 
H

Hanamachi

the problem is i want to enter a date that is not now something like 10--5-2005
 
K

Kevin B

If the field is a Date data type enter the update value as follows:

#10/5/2005#
 
H

Hanamachi

so is it possible to enter a date or data or name i choose and have it
entered automatically across all my records?


thanks
 
J

Jerry Whittle

First you need make a complete backup of the database file just in case
something goes wrong.

Next either create or use an existing field in the table. The field type
should be Date/Time.

Open up a new query based on the table in question. Pull down the date/time
field into the Field of the first column. Run this query to see what data
shows up. Ideally there will be nothing but empty fields. If any have dates
in them, you will be overwriting those values with the new date.

Go back to design view and go up to Query on the menu. Select Update Query.

In the Update To box under the date field heading, put something like the
following:

#12/6/2007#

The #'s tells Access that it's a date which you want to enter. Run the
query. After a while it will ask you if you really want to update all the
records. That's your decision.
 
H

Hanamachi

ok got that part, thanks, then how would I combine 2 huge databases into one?
 
Top