Specify fields to exact report locations?

[Rich Sullivan]

Using Access 2002, would it be possible to populate a report with fields
from different tables? In a freeform manner, something like:



Table 1.field2

Table4.field3 Table2.field1 Table3.field2

Table3.field3

Table 4.field1 / Table1.field3 (this one is a calculated value)



Would it be necessary to use VBA or Visual Basic? This could also be a form
instead of a report if that would be easier to do. The goal could be either
to fill out a preprinted form or a technical report where it isn't obvious
how to group the data.

Thanks in advance for any help on this one!

 

[Duane Hookom]

Usually if you want to print a bunch of values in a report, they are somehow
related. You can create multi-table queries, use reports with subreports, or
write code in the report to either fill unbound text boxes or use
Me.Print...

 

[Jeff Boyce]

Rich

Duane pointed out that reporting data from multiple tables in a relational
database (e.g. Access) usually means building the queries that pull together
the data from the related tables.

If, in your case, you have totally unrelated tables but want to have data
from several (though I must say, I can't imagine the circumstance right
now), you might consider using subreports. You could create a single "main"
report, and create/embed multiple subreports.

Good luck

Jeff Boyce
<Access MVP>

 

[Rich Sullivan]

Let me be more specific.
Actually I had two different things in mind.

In the first case the tables would be the process data of a factory
laboratory. Some of the data is related and some isn't at all. But it gets
published all on one report. But the one common relationship that would tie
all the data tables together would be the Date since the process data is for
3 shifts /one day of production. All Tables would have a Date and Time
field. Each day would have a set of summarized results/totals/averages by
the hour & shift as well some specific (once daily) tests.

In the second case, I had in mind producing labels. Lets say three across
like this (hope this comes through
corrrectly formatted) Field1 is small enough to fit on the middle (second)
label for two sets of labels. Don't want to waste
labels, there will be many to print.
First Label Second Label
Third Label
Table1.Field1.recordset1
Table1.Field1.recordset2
Table1.Field2.recordset1 Table1.Field1.recordset1
Table1.Field1.recordset2 Table1.Field1.recordset2
Table1.Field3.recordset1
Table1.Field1.recordset2
The first label contains three fields of recordset1, the second label just
the first field of first & second recordsets, etc
The next line would be 3 & 4th recorsets etc
I wanted to know if Access could do this, and could it be done with or
without VBA code or what. To position the recordsets in a sort of free/form
pattern, Thanks again in advance. You've already given some goog ideas!

 

[Duane Hookom]

Divide and conquer. Find small groups of records from common tables and
build parts. You can later place them together on a main report and relate
them by Date or other field.

You may have to make some compromises regarding the layout.