passing arrays io a report

[Seamus59]

I have created a public variant and defined it as an array. All my functions and procedures seem to be able to access the aray, but my report does not. Can anyone tell me how to pass this information to my report (other than OpenArgs)?

Or, as my report rolls through a table, I could get this set of values out of a different table, I'm don't know how to access two recordsets in one report.

The goal is to multiply a set of fields for multiple records in one table by a set of values in single record of another table.

TableA|Table B
2 3 4|--|2 2 2
1 3 5
3 3 3

Report
4 6 8
1 6 10
6 6 6

[pbaldy]

If the second table contains a single record, you can base the report on a query that includes both tables.

[Seamus59]

If the second table contains a single record, you can base the report on a query that includes both tables.

Simple and elegant, thanks.

[pbaldy]

No problem, and welcome to the site by the way!