Reports

G

Gianni

I'm trtying to run a report from a Crosstab query.
Some fields on the crosstab field are empty because no figures are available.
When i try to run a report adding the different field I do not get a total
becasue some fields are empty.
There is anyway to replace the empty fields with a 0 value so the sum will
run?
Thank you for your help.
 
D

Duane Hookom

1) what is the SQL view of your crosstab query?

2) in the future, consider typing in a more descriptive Subject. "Reports"
is about as non-descriptive as you can get in a news group that deals only
with Access reports.
 
Top