dlookup in detail section

  • Thread starter Steel via AccessMonster.com
  • Start date

S

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.
 
Ad

Advertisements

M

Marshall Barton

Steel said:
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup in Detail 7
Detail Section 2
Section Detail 1
Detail section 4
Detail Section Limitations 2
Hiding Section Detail 7
Count in Detail Section 1
report detail section 2

Top