Dlookup by Header 1

[abradford]

Can you have different Dlookup values on a report by header? I have a report which dispalys certian people from multiple offices, grouped by office. I have a office header and am trying to use Dlookup to dispaly total number of people from that office, stored in a lookup table. Is this possible?

so if office is 3029 dispalyed in the office header, i would like the Dlookup function to fetch the total number of people in office 3029 and place on report...

=DLookUp("total","Lookup","BSONum = " & [BSO]) is not working.

thanks.

 

[dhookom]

Is BSONum numeric or text? Your expression should work for numeric if BSO is a field in your report, Lookup is a table or query, and Total is a field in Lookup.

If BSO is text, try:
=DLookUp("total","Lookup","BSONum = """ & [BSO] & """")

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[abradford]

It is numeric, and I tried =DLookUp("total","Lookup","BSONum = """ & [BSO] & """"), however nothing is appearing on the report. No error message either. The box is visable... this in not a parameter query/report just to mention.

 

[abradford]

got it. thanks!