hi all, sorry for my late reply, ive actually been quite sick for the past couple days. I guess what i wanted was to set up (except as an append not a cross tab) a cross tab with: Fruit as a row header; parameter as a column header (except chose only the parameters i want); and value as value. Hope thats not too confusing.. =P

Edit:

JimmyTheHand: Hey there, i tried out ur code, and i got the fields, but the entries were empty. Hehe, but with some minor modifications it could work nicely thanks

Alimcpill: I was thinking about doing it this way, but i was not quite as familiar with cross tabs when i started and i didnt like having to export the table (it would take 5 minutes to run the query to see if i got it right and then 5 minutes to export since it always reruns the query =S) but ill start off by using this query.

Thanks you 2