Combining Lines of Data in Qry

[Maverick28]

Hi all,

I`m new to the forum and in search of help/wisdom!

I have a data set in the same layout, albeit different data:




What I need to do is move it to a layout as follows:


Can anyone advise how to get this done in a query?

Thanks in advance!

Scott

[ranman256]

this is a CROSSTAB query.
Use the query wizard, it will ask what fields you want as row heading,col heading, and values.
(you wont need row 1 in your example ,everyone knows what a MONDAY is)

[Maverick28]

this is a CROSSTAB query.
Use the query wizard, it will ask what fields you want as row heading,col heading, and values.
(you wont need row 1 in your example ,everyone knows what a MONDAY is)

I`ll give that a go! thanks!