Reporting From More Than One Table

[Jim]

Hi,

I have a requirement to display the software version number in
the header part of my reports. The software version number is stored
in a table that is different from the table that is used for the report
data.

I dropped a text box in the header part of my form. Set the
ControlSource property and the Expression editor appears. I set the
expression to tblVersion!Major which is the table and field containing
the software version.

When I flip the report into Preview mode, it prompts me with a
parameter box that says tblVersion and awaits input.

This is not what I want to happen, I just want it to display
the data in the table.

Can someone tell me how to do this?

Jim

 

[Guest]

Do it in a query. Left join the two tables on the common field the two
tables have such as the software ID.

 

[Guest]

Jim:

I take it that tblVersion has just one row. In which case you can use the
DLookup function to get the value of the Major column by setting the
ControlSource of an unbound text box to:

=DLookup("Major", "tblVersion")

Or you can just add tblVersion to the report's underlying query, but don't
join it to any other table. You can then simply bind a text box to the Major
field.

Ken Sheridan
Stafford, England