?
Solved

Error: Access Unknown

Posted on 2006-11-21
1
Medium Priority
?
169 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
Ajay-Singh earned 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month12 days, 13 hours left to enroll

777 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