cross tabs ???????????????????????

[paulmcdonnell]

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

 

[paulmcdonnell]

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

paul