Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. numbercruncher

    Counting data from multiple fields

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

    Counting data across multiple fields

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

    Counting data from multiple fields

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

    Counting data across multiple fields

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

Part and Inventory Search

Back
Top