Just a quick question (MK8WR - are you there ?)

philbennison

Registered User.
Local time
Today, 21:46
Joined
Nov 10, 2004
Messages
49
Thanks to all you guy for the help building my database :)it is now working, however MK8WR gave me a sample database that updated 'working_days' when a start or end date was updated. Brilliant.
I have now imported over 2000 records and am ready to roll. Is there a quick was to get 'working_days' field updated without editing the date on every record ??

Any ideas

Phil
 
?

How do I do that ?
 
Create a Query, select UPDATE Query from the Query menu, and change the field you want to the new formula you have.
 
i dont have that option

When i click on new, i dont have the option to create an update query. i am running access 2000
 
Go to new then design view - add the tables. Then on the menu bar you should have "queries" as an option, select "Update"

Col
 

Users who are viewing this thread

Back
Top Bottom