I don't know if this is the proper group to post this message into, but I'll
start here and see what happens. To try and "simply" explain my request......
I know this can be done, as I've seen the results, but I can't figure out how
to do it. I want to use the Report function of Access to create printed forms.
I would have different reports, named A, B, C, D, and E for this example. The
information I want to have printed on the report(s) comes from one specific
table. On report "A" I want to have the values printed that are in rows 2,3,
and 5 of "column B" (forgive the Excel term) in the table; on report "B" I
want to have the values printed that are in rows 2,4, and 5 of column B in
the table; on report "C" I want to have the values printed that are in rows 4,
5, and 6 of column B in the table; etc.
I don't know if I can somehow do something with expression builder for the
control source of a label box. I tried, but I'm still fairly new to Access,
so I couldn't figure it out.
Also, there would only be one value per label box; i.e., value from B2 in
table would be in one label box, value from B3 would be in another label box.
Any assistance that could be obtained would be appreciated.
Allen Browne - 13 Mar 2007 01:12 GMT
Use DLookup().
The Control Source of the text box on the report will be something like
this:
=DLookup("[Field2]", "Table1", "[Field1] = 5")
For more help, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>I don't know if this is the proper group to post this message into, but
>I'll
[quoted text clipped - 27 lines]
>
> Any assistance that could be obtained would be appreciated.
orgelizer - 13 Mar 2007 18:42 GMT
Thanks for your info. It does exactly what I was looking for.
>Use DLookup().
>
[quoted text clipped - 12 lines]
>>
>> Any assistance that could be obtained would be appreciated.