update/amend querie woes!

[Holmes]

Hello,

I have a table exported from excel. I intially imported this in to access to form a list of due dates for services.

Every week I get and e mail with the updated version.

I am trying to figure out how to update the dates in the 1st table with the new weekly ones.

I can't get it to update. Also there may be the addition of new services as well.

Any tips would be grealty recieved.

Many thanks in advance.

 

[pbaldy]

I suspect the reason no one has answered this is you haven't really given us enough to go on. You say you can't get it to update. What have you tried? What happens when you try it? What is the structure of the table (both actually)? Maybe this will help:

http://support.microsoft.com/kb/208870/en-us

 

[Holmes]

Ok

I have tried writing an update query and have also tried the link sugested.

In update to I have this:

Field: Next Service Due Table: tblServiceDue Update To: [tblServiceDueTemp].[Next Service Due] Field: Start Date Table: tblServiceDue Update To: [tblServiceDueTemp].[StartDate]


tblServiceDue= Original table
tblServiceDueTemp = weekly version.

so I want to take the next service due from tblServiceDeTemp and amend the service due date in tblServiceDue.

Similarly I want to do the same with start date, update tblServiceDue start date from tblServiceDueTemp.

When I try runnining my query (only listing Service Due and Start Date in requried fields) Service Due gets filled with :

Field: Next Service Due Table: tblServiceDue Update To: [tblServiceDueTemp].[Next Service Due] Field: Start Date Table: tblServiceDue Update To: [tblServiceDueTemp].[StartDate]

Any ideas?