Recent content by leighturner

Thank you for the confirmation. Unfortunately I am receiving "Invalid Outside Procedure" on compile. I tried your code first, then modified to this: Option Compare Database Option Explicit Private counter As Long counter = RunTot3 If counter > 18 Then counter = 1 End If...

Thank you for your response. I understand what you have explained with the code but do not understand the declarations sections??

Designing a new report appears to be the only option, would it be possible explain the process of my requirement if I were to complete this inside a report?

Hi RainLover, I dont want to be a pain but have you had chance to look into my query at all? - I am still at a total loss.

Hi jzwp22, I just want to add 1 to the PalNo value for every record. Thanks in advance.

Thank you very much RainLover. Would it help if I sent you the data?

Thank you for your replies and help so far. Basically now I have my running total working, I would like a further query to monitor the running total, when the running total reaches >=18 reset the RT by taking the BoxCount query that the RT is using, this query or another query would then...

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!

Thank you so much RainLover... That worked an absolute treat, I cannot thank you enough. I have another question, sorry. Is it possible to reset the balance running total once a value is reached?

Thanks for the quick response vbaInet. Could I not create a new running total field based on current box count data? ID Boxes RunTot 1 126 126 2 7 133 3 13 146

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

Yes it would be a running total. I will not be using a form. I will probably be opening the query using code if I can gather any examples!

Providing the syntax was right, something like this would achieve New Pallet: (if count(BoxCount/6)=18 then ("New Pallet")) and then reset the count.

Once the count has reached 18, the proposed field will tell the operator that it is time to start a new pallet. Does this help?

This is worked out based on pallets and boxes. (Rounded up) 14/6=3 14/6=3 13/6=3 8/6=2 12/6=2 11/6=2 13/6=3 -----> Start of new pallet 13/6=3 8/6=2 12/6=2