Index Fields

[bw]

I seem to remember seeing a report that used indices to refer to the field
header, and control.

I have a table that has just a few fields, that may contain many values,
like the following example:
FieldName Value Amt
TestName 1 $50
TestName 4 $1
TestName 2 $23
and the table goes on with TestName2, TestName3, etc

So I'd like to design a report so that I could fill the Field Headers and
Controls using an index, something like:
ValueControl(0)=Value
AmtControl(0)=Amt
and do this for all Records in the file, but only one line for each
FieldName.

The Headers and Controls might even go on to multiple lines on the report,
but a one line report would look something like this:

FieldName Value(0) Amt(0) Value(1) Amt(1) Value(2)
Amt(3).....etc.
TestName 1 $50 4 $1 2
$23
TestName2 2 $14 9 $2 4
$35


Can anyone provide me with a sample report like this, or explain how I
should proceed?

Thanks for the help,
Bernie

 

[Duane Hookom]

I would create a main report based on a query like:
SELECT [FieldName]
FROM tblNoNameGiven
GROUP BY [FieldName];

Then create a multiple column subreport based on tblNoNameGiven. Stick this
subreport in the detail section of the main report.

 

[bw]

Well Duane, that's not was I was asking, but of course, your solution is
much better (and easier) than what I had envisioned.

Thanks much for your help.
Bernie

I would create a main report based on a query like:
SELECT [FieldName]
FROM tblNoNameGiven
GROUP BY [FieldName];

Then create a multiple column subreport based on tblNoNameGiven. Stick
this
subreport in the detail section of the main report.
--
Duane Hookom
Microsoft Access MVP

I seem to remember seeing a report that used indices to refer to the
field
header, and control.

I have a table that has just a few fields, that may contain many values,
like the following example:
FieldName Value Amt
TestName 1 $50
TestName 4 $1
TestName 2 $23
and the table goes on with TestName2, TestName3, etc

So I'd like to design a report so that I could fill the Field Headers and
Controls using an index, something like:
ValueControl(0)=Value
AmtControl(0)=Amt
and do this for all Records in the file, but only one line for each
FieldName.

The Headers and Controls might even go on to multiple lines on the
report,
but a one line report would look something like this:

FieldName Value(0) Amt(0) Value(1) Amt(1) Value(2)
Amt(3).....etc.
TestName 1 $50 4 $1
2
$23
TestName2 2 $14 9 $2
4
$35


Can anyone provide me with a sample report like this, or explain how I
should proceed?

Thanks for the help,
Bernie