Search results for query: *

I need to fill the field values that have been returned empty on a crosstab query. Or if there is a way to add fields values including empty ones.eg mon tues wed thur fri total 3 4 1 1 3 12 2 2 1 2 1 4 2...

i have set up a query to summarise 14 crosstab queries the only problem is that it doesn't do the sum if any one field value is empty, and as it is a crosstab query i can't input a 0 manualy. Does anyone know a way of making this sum include empty field values Expr1: ([mon am...

I am attempting to count different field values [a], [s], [ua] from 14 fields. So far i have produced numerous solutions which fall just short of successful. I have tried crosstab queries but i can't get them to total. If anyone can think of a way to count text field values i would be immensely...

I am simply tring to count number of [a], [s], and [ua] which are all field values, if there is an easier way then please let me know. I have got 14 crosstab queries to count [a] in each field which work perfectly. When i try adding them together using; Expr1: ([monday am...