Search results for query: *

if i enter either of these in the expression builder it returns a syntax errors. Where should i be entering them? Thanx 120282

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...

THANX WORKED A TREAT!

to count the number of records where the code is [a]

basic outline; two tables one to many relationship. table 1 = persons details table 2 = persons timesheets broken down into hours(fields) and codes(fields) per half day. i am trying to total the number of [a], a value from the codes field for each person. Thanx 120282

No they are text fields containing various code such as [a], [s] etc. on a look up wizard. I need to total the number of each code for each person. if that makes any sense at all. Thanx 120282

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...