Showing table fields in a report

[BIGGY]

Pretty basic here I hope. 4 different tables, each has just one record with several different fields. In 4 different places on the report I want to display most of the fields from most of the tables in a specific format, such as FIELD1 and FIELD2 from tbl1 being right next to each other followed by FIELD3 and FIELD4 from tbl1 to be right below. And then do this in several different spots on the report for the rest of the tables.

 

[Pat Hartman]

If there is some relationship between the tables, you can create a query that joins them and use that query as the RecordSource for the report.

If there is more than one 1-many relationship and they are not hierarchial, you'll need to use subforms for each of the many-side tables.

Another possiblity is to use DLookup()s.

 

[BIGGY]

I just tried simply using the toolbox to create a 'text box', should that work? From there I simply select the control source table and field that I need such as... =tbl1!Field1

However when I try to view the report it only shows #NAME?

 

[Pat Hartman]

No. That won't work. You could use DLookup() if you can't join the tables because there is more than one 1-many relationship.

 

[BIGGY]

Ok, this would be new to me...how would I use the dlookup? Let's say I'm starting off with a blank report...

 

[RV]

See Access Help for info on Dlookup or do a search on the forum.

RV

 

[Pat Hartman]

DLookup() is a function (it is also the least desirable of the alternatives I mentioned). It can be used wherever a function can be used. So the ControlSource where you want the value to be displayed would be:

=DLookup(......)

Fill in the dots.