I have a report that is broken down and grouped by carton number and then by an audit code. What I need is for a "1" to show for each line of the audit code and a "0" to show for each following record (if there are any) until the next carton , then another 1 followed by 0 etc. etc.
carton number 999999
1st audit record 1
2nd audit record 0
3rd audit record 0
carton number 888888
1st audit record 1
2nd audit record 0
next carton.....
How can you code a textbox to show the 1 only in the first record?
(don't really need the 0, it can be blank, if easier)
carton number 999999
1st audit record 1
2nd audit record 0
3rd audit record 0
carton number 888888
1st audit record 1
2nd audit record 0
next carton.....
How can you code a textbox to show the 1 only in the first record?
(don't really need the 0, it can be blank, if easier)
