Search results

I would like to increment a value stored in my sys table by 1 for every record in my query. ID PalNo 1 100 Initially I though counting this field would do the job, for example: Pallet: (Count[PalNo]+1) Help please!

My running total based on box count is not producing a running total for each record? RunTot: DSum("BoxCount","FRA 799 Value Card","BoxCount") For example box count data: 126 7 13 8 10 7 13 8 7 Running total is showing 199 for every record What I am trying to achieve is the following...

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...