cross tab query in a form problem

[ros794]

Hi,

I have created a form that is based on a cross tab query. I have a set number of fields in the form (1 day, 2 days, .....10 days).
The problem is sometimes when I run the query some fields disappear. for example for no records have an entry in the '2 days' field.

When this is out through the form then that whole column will read '#Name?' for all entries.

Is there some way I can clear the '#Name?' entry or replace with a zero on the form?

Hope anyone can help!!

Thanks!

 

[Jon K]

You can add an IN clause in the SQL statement of the crosstab query.

Take a look at this thread:-
Crosstab #Name? Problem
http://www.access-programmers.co.uk/forums/showthread.php?t=100617
.