Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2007

Tip: Looking for answers? Try searching our database.

Copy Specific Values from Table to Report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
orgelizer - 12 Mar 2007 22:55 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.