Show spreadsheet

[Naz]

Hi

I have a table with employee absence data ID, Startofleave, endofleave,
NoOfDays, TypeOfLeave

Initially i wanted to show a Gannt type like thing with employee ID on the
left side and all the years date as column headings and then the dates
absent/sickness type as data, but after various mess about with Crosstabs,
charts, etc...i think i won't be able to do that....

.....so my plan B is if i can get the data i want into an Excel spreadsheet
(which i can do) i can then manipulate it, fiddle it about etc

But my problem with this method is how do i get it to show in a form like a
sub form control?

All help is appreciated.

 

[Peter Hibbs]

Naz,

A Flex Grid Control will probably do what you want but it will involve
a fair bit of VBA code. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[Klatuu]

Naz, go with Peter's suggestion. The only thing slower than an Excel sheet
in a bound object frame is my 91 year old aunt.