G
Guest
Have a report based on a query. The query has a column
named Number that has numbers from 1-100. Have a column
with expression: Pallet#: ([Number]\4+1. The results I
wanted were to have Pallet# repeat every four records.
Example Numbers 1 thru 4 in the Pallet# column would say
1, Numbers 5 - 8 would say 2, etc. The problem is that
records 1 thru 3 are Pallet#1, then after that it is every
four records which I wanted. It just does not do it on
the first four. I have tried many iif statements such as
=iif ([Numbers]<5,[Numbers]\5+1,[Numbers]\4+1), which
works for 1st four records, then second series has 3
repeat records then it goes to four again. Can't figure a
way to get first 4 records to repeat correctly. Do you
have any suggestions? Thank you....
named Number that has numbers from 1-100. Have a column
with expression: Pallet#: ([Number]\4+1. The results I
wanted were to have Pallet# repeat every four records.
Example Numbers 1 thru 4 in the Pallet# column would say
1, Numbers 5 - 8 would say 2, etc. The problem is that
records 1 thru 3 are Pallet#1, then after that it is every
four records which I wanted. It just does not do it on
the first four. I have tried many iif statements such as
=iif ([Numbers]<5,[Numbers]\5+1,[Numbers]\4+1), which
works for 1st four records, then second series has 3
repeat records then it goes to four again. Can't figure a
way to get first 4 records to repeat correctly. Do you
have any suggestions? Thank you....