Columns in a report

[SiouxieQ]

Hi,

I've seen this done but can't figure out how to do it myself.

I have fields I have brougt together in a query from 2 tables.

I want the date/day of the week to act as a heading for the columns of the
report, this is currently one field in the table.

I then want other information ie menu items for lunch/dinner to list beneath
the date/Day of the week.

How do I get the field for the date to list across the top of the report
instead of down the page?

Cheers Sue

 

[Jeff Boyce]

If you are saying that the date/dayofweek is a field in your query and you
don't want to see it repeated in each row of your report, there's a couple
ways to handle this.

One would be to set the "Hide Duplicates" property of that control on the
report to "Yes".

Another would be to use that field to "Group By" in the report -- this would
create a Group Header section in which the date/dayofweek would show up
once, and the Detail section would hold all that day's details.