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