I'm using a cross tab query to fill in a grid of types of appointments made by consultants over a peiod of time...
When the cross tab query runs if any appointment type has no summary values the whole feild is not reported on and only those with values are returned.

Consequently the form I set up shows "Name?" in these feilds because there's no reference...

How do I get the query to report the fields even when there are no values, or get my form to diplay a blank or ) if Name? should appear.

Basically I want to get rid of the Name? references which clutter my otherwise informative form...

ANY IDEAS


CHEERS


PAUL

If you want the crosstab to produce a fixed set of columns, put all the possible values in the ColumnHeadings property. To do this, open the query in design view and open the properties list. You will see the ColumnHeadings property.

Cheers PAT.. Worked Great...
Appreciated.....

paul