Recent content by numbercruncher

Thanks for your comments fmbpcsup. I am not concerned with null entries particularly. I am trying to summarise information across all the potential types of answers. For example a sample output would look something like what follows: PersonID OutcomeType Field1Count Field2Count A100...

Thanks for responding Jerry. I am not actually setting any criteria. I think a better illustration may help. Imagine the following table : Person ID Field1 Field2 Field3 a1 2 4 5 b2 1 3 5 c3 2 3 4 Now...

Hi folks I am having difficulty in counting the contents of multiple fields using queries. I have used the group by and count tools in the query design view but this is only good for single fields. For example, you need to select a field to group by therefore if data in another field is not...

Hi folks I am having difficulty in counting the contents of multiple fields using queries. I have used the group by and count tools in the query design view but this is only good for single fields. For example, you need to select a field to group by therefore if data in another field is not...