Solved

Error: Access Unknown

Posted on 2006-11-21
1
165 Views
Last Modified: 2010-03-31
Hi,

I have following query:  trying to update several fields in table based on value that is entered in each field on every wednesday.

UPDATE tblAMKCGP
SET [SystemGP/FR] = DLookUp("[SystemGP/FR]","tblAMKCGP","weekday(tdate)=4 and (tdate>date()-7")
And [SystemGP/BA]=DLookUp("[SystemGP/BA]","tblAMKCGP","weekday(tdate)=4 and (tdate>date()-7")
And [SystemGP/SP]=DLookUp("[SystemGP/SP]","tblAMKCGP","weekday(tdate)=4 and (tdate>date()-7")
And [Systemother]=DLookUp("[Systemother]","tblAMKCGP","weekday(tdate)=4 and (tdate>date()-7")
WHERE (((Weekday([tdate]))<>4) AND (([tdate])>Date()-7));

Can't figure it out? Help
0
Comment
Question by:sikan71
1 Comment
 
LVL 23

Accepted Solution

by:
Ajay-Singh earned 125 total points
ID: 17993918
this query updates tblAMKCGP table setting

SystemGP/FR field to the value of column "SystemGP/FR" of table "tblAMKCGP" only if "weekday(tdate)=4 and (tdate>date()-7" is true.

same for other fields


more on DLookup: http://support.microsoft.com/kb/208786
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
split53 challenge 7 95
eclipse argument 14 60
by zero exception 10 39
Facing this issue for maven proxy setting 2 9
For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

806 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