1st off this is my first post ever! This forum has been helpful solving any issues I've had so far through diligent searching. This was the only one i couldn't find... Maybe not searching with the right terms? If its already answered let me know.
Not sure yet what i would need to make this happen, which is why i posted in general access questions, vs specific to macro or query.
I have a big explanation behind exactly what i want to do, but figured it best not to make the 1st post on the question a massive undertaking.
Quick version:
Lets say i have imported 400 records in order of sequence from excel. But without a sequence/group number.
I want a unique sequence number with an interval of 30 records (for instance) instead of every record having a unique sequence, counting down from 1.
The idea behind it, is to show what group the process is currently on. The carts are sorted in order of date (column not shown) And are to be done roughly in order (within a margin of 30 for instance)
The group # would be displayed. If an item is scanned and it falls outside of the current sequence (ie. late, or early) then an alternate process is to follow. That is no problem. Only issue is getting that group # assigned to the records.
Table example (Being compressed to 8 records instead of 60)
EX of what i currently get:
ID QTY Cart# Data Group# 1 18 654664 TMP/MPL/WC 1 2 5 980734 TMP/MPL/WC 2 3 4 726354 TMR/MPL/WC 3 4 2 19385 TMP/MPL/WC 4 5 1 762098 TMR/MPL/WC 5 6 3 892376 TMP/MPL/WC 6 7 3 927843 TMP/MPL/WC 7 8 2 17684 PAL/MPL/WC 8
EX of what i want:
ID QTY Cart# Data Group# 1 18 654664 TMP/MPL/WC 1 2 5 980734 TMP/MPL/WC 1 3 4 726354 TMR/MPL/WC 1 4 2 19385 TMP/MPL/WC 1 5 1 762098 TMR/MPL/WC 2 6 3 892376 TMP/MPL/WC 2 7 3 927843 TMP/MPL/WC 2 8 2 17684 PAL/MPL/WC 2