Grouping Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that shows a list of parts and the total quanity of these parts required
I would like if possible to add a text box? that counts the total quantity of parts and when this total reache
about 960 it, A. forces a new line in the report and B. resets the counter in the text box? to zero ready for the next 96

Is this possible

Any help would be most greatful

Thank You
 
I don't really know what you want in the 'extra line' when count reaches 960, but I'll give an example that the new 'line' is a textbox which is blank until count reaches 960, whereby it will then start recording the number of sets of 960 that have passed
You would have the 2 textboxes permanently visible and use calculations to set what (if anything) is displayed in them

"Air-code" as the programmers call it

textbox A = Iif(Count(parts)<960,count(parts),count(parts)-int(count(parts)/960)*count(parts)

textbox B = Iif(Count(parts)>=960,int(count(parts)/960)) & " completed sets

Bear in mind, when the count is 960 here, it will show 0 in textbox A and "1 completed sets" in textbox B
Textbox B (as long as you make it transparent with transparent border) will not be visible until the count has reached 960

Hope it gives you an idea

Basi

----- David wrote: ----

I have a report that shows a list of parts and the total quanity of these parts required
I would like if possible to add a text box? that counts the total quantity of parts and when this total reache
about 960 it, A. forces a new line in the report and B. resets the counter in the text box? to zero ready for the next 96

Is this possible

Any help would be most greatful

Thank You
 
Back
Top