By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 1,034 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

DLOOKUP vs FIND For Values as Field names

P: 3
i read the thread entitled "Convert Field Value String to Actual Field in Expression"

It appeared that the final solutions got moore complex not less complex

MY PROBLEM IS:
1. get a value from one table as a string "C"
2. lookup the value of a field in a TABLE2 "CD"
where the field name = the value of field in TABLE1

I CAN GET THIS USING DLOOkUP, BUT NOT BY FIND METHOD
example:
TABLE1 - 3 FIELDS (50 parts, 1 code and 1 item per part)
(part as string)+(code as string,3) + (item as string, 255)
99 choices for code are (HD01->HD99)
ex: c = value from TABLE1 (if [PART] - "AN" then c = "HD05")

TABLE2 - 100 FIELDS (1 ID, 99 dates) FOR SPECIFIC PERSON
(ID as long) + (HD01) .. (HD99)

ex CD = DLookup("" & C & "", "", "ID = " & PATID)
(find record using findfirst and get value from field "HD05")
Returns CD = #02/03/2006#

I am under impression that using DLOOKUP is slower than using the FIND Method.
If so, what I want is:

TABLE2.FINDFIRST ("ID = " & PATID)
C= "TABLE2" & C
RETURNS "C = TABLE2!HD05"
CD = C
CD = #02/03/2006#

What I get is
CD = "TABLE2!HD05 "



Any Ideas?
Oct 22 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi
It's like a double post, but the content is different from your previous one...

And the question is more clear!

Definitely the Dagregate functions are the worst thing you can use! They lock your tables seek poorly and in network environnement are really poor...

If you use them in Append query for exemple and you do a sum of the previous values of the introduced till the current record records it will be faulty! It will be faulty either if you don't use transactions!

Those functions can create only problems in multiuser environnement!
:)
Oct 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.