DLookup with multiple criteria

[Guest]

Hi


I need to use DLookup to lookup a value for my report in a table but it
needs to be based on 3 criteria in the report.

What I need to look up is ScheduledHours from tblLeadInfo based on Week,
Period and Ride in the current grouping on the report.

As always Thanks in advance for any help on this

Chuck

 

[Stefan Hoffmann]

hi Chuck,

I need to use DLookup to lookup a value for my report in a table but it
needs to be based on 3 criteria in the report.

What I need to look up is ScheduledHours from tblLeadInfo based on Week,
Period and Ride in the current grouping on the report.

Something like this will do it:

DLookup("ScheduledHours", _
"tblLeadInfo", _
"[Week]=? AND [Period]=? AND [Ride]=?")


mfG
--> stefan <--