Hello,
New to this list. I am an Accountant who dabbles in Access but have never got into programing. I have an issue I think may require some coding.
I want to count and number each time a specific item appears in a field and return the results in a query.
For example I have a table with 8 records in the "Ref" field:
Ref
1234
2234
3234
4234
5234
6234
7234
7234
Note that "7234" apears twice.
After I run my query I want to see the following results:
Ref Count
1234 1
2234 1
3234 1
4234 1
5234 1
6234 1
7234 1
7234 2
Purpose - I am trying to create a key field. In real life the "Ref" field is a transaction reference number for a credit card and it is unique. But, our corporate card holders have the ability to allocate a specific transaction to multiple expense accounts, such a one hotel bill to room, meals, entertainment, etc. This allocation creates multiple instances of the same "Ref." I will use the query to again make each item unique.
Thanks.
New to this list. I am an Accountant who dabbles in Access but have never got into programing. I have an issue I think may require some coding.
I want to count and number each time a specific item appears in a field and return the results in a query.
For example I have a table with 8 records in the "Ref" field:
Ref
1234
2234
3234
4234
5234
6234
7234
7234
Note that "7234" apears twice.
After I run my query I want to see the following results:
Ref Count
1234 1
2234 1
3234 1
4234 1
5234 1
6234 1
7234 1
7234 2
Purpose - I am trying to create a key field. In real life the "Ref" field is a transaction reference number for a credit card and it is unique. But, our corporate card holders have the ability to allocate a specific transaction to multiple expense accounts, such a one hotel bill to room, meals, entertainment, etc. This allocation creates multiple instances of the same "Ref." I will use the query to again make each item unique.
Thanks.