Helo All,
I have been fussing around with a crosstab query - works fine.

I need to drop into a table in the same format as it is being viewed,
however it doesn't separate the data when I make table or append I
lose the columns.

Using
TRANSFORM Count(q_bookingDates.book) AS CountOfbook
SELECT q_bookingDates.SchDate, q_bookingDates.session
FROM q_bookingDates
GROUP BY q_bookingDates.SchDate, q_bookingDates.session
PIVOT q_bookingDates.S_year;


I am trying to export the fields n the following format:
date |session |2 |3 |4
2011.09.05 AM 1 0 0

1 being boolean Yes, 0 boolean No


However I end up with
date session
2011.09.06 00:00:00 AM 1

Whenever I try to format the fields in the query I lose the columns...

Ultimately I need to use the export query code, but I simply cant find
a way through this formatting issue
Any suggestions or help would be appreciated

Thanks
John

On Aug 23, 11:58*am, flymo <fly... (AT) hotmail (DOT) com> wrote:
DOH!

Fixed
Created new query, dropped crosstab in, make table....all done.

Cheers
John