Change multiple lookup fields at the same time

's Computer Specifications

I'm not sure if there is a macro for this but I have a few thousand entries
in my database that I have imported from excel spreadsheets. I have added a
status column to the datasheet and would like to change them all to complete.
Is there a way to do this?

's Computer Specifications

Run an update query to change the value in that field to what you want.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

"JLDLS" <(E-Mail Removed)> wrote in message
news:311E40BD-992A-44A3-83E1-(E-Mail Removed)...
> I'm not sure if there is a macro for this but I have a few thousand
> entries
> in my database that I have imported from excel spreadsheets. I have added
> a
> status column to the datasheet and would like to change them all to
> complete.
> Is there a way to do this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup selecting from multiple fields	Shan	Microsoft Access Database Table Design	1	1st Oct 2009 04:34 PM
Multiple Lookup Fields	Melissa	Microsoft Access Forms	1	22nd Sep 2008 07:23 PM
Lookup with multiple Fields	CHess	Microsoft Access	3	31st Dec 2007 03:54 AM
In a lookup column, looking up multiple fields, can I change whic.	=?Utf-8?B?cnRodW5kZXI3OA==?=	Microsoft Access Getting Started	1	22nd Feb 2005 07:35 PM
Lookup Field in a form with multiple fields	Mike	Microsoft Access Database Table Design	2	2nd Nov 2003 01:04 PM