Using Dlookup with multiple fields to display one field
Posted on 2013-10-30
I have a Table [IEGDate] with 4 primary key fields; [Effective], [HHSize], [Frequency], [IncomeType] with a non-primary key field [IncomeThreshold].
I also have a form [IEChild], with fields [HHSize], [HHIncome] and [Frequency]. I need to lookup these 3 fields in the [IEGDate] table and return the [IncomeType] on this form. The [HHIncome] field would correspond with the [IncomeThreshold]. In summary, the fields [HHSize] and [Frequency] must match and the [HHIncome] must be equal to or less than the [IncomeThreshold] to display the [IncomeType]. If the [HHIncome] is greater than the [IncomeThreshold], display "No".
Can you assist?