Copy Specific Values from Table to Report

[orgelizer]

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]

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

 

[orgelizer via AccessMonster.com]

Thanks for your info. It does exactly what I was looking for.

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

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.