producing a 2d spreadsheet

[Rat1sully]

I have a query that pulls data from my database in the following format:

EquipmentName Catagory Platform PlatformClass

what I need to do with this is product a spreadsheet that has the EquipmentName along the Y axis, the Platform listed along the X axis and the cell to do a presence check to see if that bit of equipment is fitted anywhere to that class

Could someone point me in the right direction please just need a starting point really

 

[Trevor G]

Have you tried looking at a Cross Tab Query or if you want to do this in Excel then Copy the table and paste in Excel then Look at Copy and Paste Special and use Transpose

 

[Rat1sully]

Thank you for your reply, crosstab query seems to be what I was looking for googling is only as effective as the terms you use in the search it seems I shall get on with looking into these.

In short what I need to do is press a button on a form and have it either export the spreadsheed or produce a chart that says if equipment mentioned on the left is present on the class mentioned above the cell

I've got a string from my initial query that collates all the fields I figure I need, so that could be used for the classes along the top at least