leighturner
Registered User.
- Local time
- Today, 14:37
- Joined
- Dec 6, 2010
- Messages
- 16
I am trying to add a new field to an existing query that will achieve the following:
Count on an existing field - BoxCount/6: -Int(-[BoxCount]/6)
once the count has reached 18 add text “XYZ” and reset the count and repeat above process.
For example: (Based on count reaching 10)
A B C 1
A B C 2
A B C 3
A B C 4
A B C 1 XYZ
I hope this makes sense, thanks in advance.
Count on an existing field - BoxCount/6: -Int(-[BoxCount]/6)
once the count has reached 18 add text “XYZ” and reset the count and repeat above process.
For example: (Based on count reaching 10)
A B C 1
A B C 2
A B C 3
A B C 4
A B C 1 XYZ
I hope this makes sense, thanks in advance.