dlookup in detail section

[Steel via AccessMonster.com]

I have a report in which I would like to include 95% confidence intervals
that are calculated using software outside of Microsoft Access. Currently,
this report has all of the calculated fields I need to be included (except
for the confidence intervals) from a query I created. These calculated
fields are located in the detail section which is based upon year. All I
would like to do now is place my confidence intervals into the report by
manually putting them into a table and using the dlookup function to place
the correct confidence intervals into the detail section of the report.
Currently, I have code in place using Dlookup that will find a confidence
interval but I also need to include criteria that tells the function to place
the correct year's confidence interval next to the same year in the detail
section of the report. Something to the extent of: lookup the lower
confidence interval in table A when the year in the table = the year in the
report.

 

[Marshall Barton]

I have a report in which I would like to include 95% confidence intervals
that are calculated using software outside of Microsoft Access. Currently,
this report has all of the calculated fields I need to be included (except
for the confidence intervals) from a query I created. These calculated
fields are located in the detail section which is based upon year. All I
would like to do now is place my confidence intervals into the report by
manually putting them into a table and using the dlookup function to place
the correct confidence intervals into the detail section of the report.
Currently, I have code in place using Dlookup that will find a confidence
interval but I also need to include criteria that tells the function to place
the correct year's confidence interval next to the same year in the detail
section of the report. Something to the extent of: lookup the lower
confidence interval in table A when the year in the table = the year in the
report.

I don't understand the problem. The way I read your
question, you just need to use DLookup's third argument:

=DLookup("conflev","conftable","confyear=" & yeartextbox)