Hi guys
This is my first post so please accept my apologies for any breaches in protocols etc.
I have a table [tblTimings] with many records. Each record contains 40 fields containing values from 1 to 100. The same value can appear in more than one field within the record.
What I want to do is create a query that counts the number of times that each value between 1 and 100 occurs in each record. I know this will create a query with 100 columns (plus the ID) and can easily do this in Excel using the Countif function but can't work out how to do it in Access.
Any help would be much appreciated
Many thanks
RobP86
This is my first post so please accept my apologies for any breaches in protocols etc.
I have a table [tblTimings] with many records. Each record contains 40 fields containing values from 1 to 100. The same value can appear in more than one field within the record.
What I want to do is create a query that counts the number of times that each value between 1 and 100 occurs in each record. I know this will create a query with 100 columns (plus the ID) and can easily do this in Excel using the Countif function but can't work out how to do it in Access.
Any help would be much appreciated
Many thanks
RobP86
Countif type code
0 commentaires:
Enregistrer un commentaire