question

PeterDelaney-8581 avatar image
0 Votes"
PeterDelaney-8581 asked

Dlookup issues with Variable as field name and date as criteria

I have a record which records the inflation number for a state based at a selected date.
- the selected date is a date variable I named "absindex"
- the states are listed as separate fields on a single record [abs qtrly index] for the selected date the key.

to identify the state a variable "Dealstate" (String variable) is defined from another record

My code is....

initialabs = DLookup("[abs qrtly index]!['Dealstate']", "ABS Qtrly Index", "[Index date]= # " & absindex & "#")

Could I obtain some help please



office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers