Question Matrix in Access..Possible?

[NewShoes]

Hey all,

Apologies if 'Matrix' is not the correct word to use but here it goes...

I'm looking at the idea of creating a sort of matrix spreadsheet type look but in Access. I need to have names down the left most column and multiple dates across the top. I could then enter a Y or N to show if that person had attended that date.

Does this sound possible? I know it's easily done in excel but I need it in Access for ease of reporting.

Thanks,
NS

 

[NigelShaw]

Hi

take a look at flexgrid. if you download the visual studio express (free) edition, you can use the flexgrid ocx for access.

google it and there is a wonder of info

regs

NS