Array as report sourse

[JimFlower]

I whish to build a data structure containing an aray of records
then display this data in a report

the data will contain multipul records of

employeeName
Week1
Week2
Week3
AvrageOfWeeks

I would rather not create temp tables or fill a table as Its for a multiuser database and i don't wish it to grow is size

is there a way I can use an aray as the reportsourse

 

[scriverb]

I would think that a query to structure the data in the manner identified and used as the recordsource would be a better way to go.

Post back with your consideration of this direction.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[JimFlower]

Thought about querys

i have time sheets and for one given week i can get a total hrs per week for each employee
then i need to extract 17 weeks from a supplied date for each employee
but if an employee was off sick or did not work then for a week i need 17+1 week and so on dynamicly

if this can be done using querys then that may solve my problem (Perpormance may be an issue)

which is why I am using code to gather my data