I have a cross tab query with parameters defined. Query runs fine. However when I run report it give me error "Microsoft access doesn't recognize as valid field or expression". So what's happening is I have 3 fields say A, B, C on the report . A is text fields others 2 are counts. If backend doesn't have data for say either field B or C then it gives me this error. Query is of full page I can post if somebody wants to see.