Recent content by sandsingh

Thanks, Brain. Let me try that one too :)

Thanks David, works wonders

When I try using the cross tab queries, Access throws up a message that it needs more than 2 fields to work with.

Table Name: BufTable Structure/Data: UserID Category U1 Category A U1 Category A U1 Category C U2 Category A U2 Category C U2 Category D U3 Category A U3 Category C U3 Category D Desired Result: UserID Count of Category A Count of Category B Count of Category C Count of Category D U1 2 0 1 0...