Dlookup MSACCESS
Setup is basic. Table (dbo_tblFMScheduleEffectiv
I need to pull the appropriate ScheduleNum based on the LoanDate falling on or between the EffectiveDateStart and EffectiveDateEnd
Attempted to use a dlookup to do this. May be a santax error, might be i need to use another method.
This is the buggy line.
intRateScheduleToUse = DLookup("[ScheduleNum]", "dbo_tblFMScheduleEffectiv
Thank you in advance!
I need to pull the appropriate ScheduleNum based on the LoanDate falling on or between the EffectiveDateStart and EffectiveDateEnd
Attempted to use a dlookup to do this. May be a santax error, might be i need to use another method.
This is the buggy line.
intRateScheduleToUse = DLookup("[ScheduleNum]", "dbo_tblFMScheduleEffectiv
Thank you in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That did the trick. TY sir.
Note that DLOOKUP will only return the first value that meets the criteria. is this application so specific that you will only have a single record that meets that criteria? If not, maybe you would be better off with a list, combo, or subform to display multiple records which meet this criteria.
Dale
Dale
ASKER
@Dale
Indeed, as this is a lookup to determine which rate set based on effective date, and no effective dates can overlap (enforced); Only one result is ever possible.
Indeed, as this is a lookup to determine which rate set based on effective date, and no effective dates can overlap (enforced); Only one result is ever possible.
intRateScheduleToUse = DLookup("[ScheduleNum]", "dbo_tblFMScheduleEffectiv
Your date variable (dtLoanDate) needs to be surrounded by pound signs.