Basic coding question...

O

orjazmik

New Member
I have a table that basically holds transactions for picks by location. There's a record for each pick that's peformed on a bin, but there's also a field in the table for the product number. What I'm looking to do is create a variable where I can count the number of records per bin, per product then display the bin location, the product number, and the number of records. I'm having some trouble getting the count and displaying the record (that will ultimately come out on a report). I don't know if this making any sens, but can anyone give any sugesstions on a good way to approach this? :confused: Thanks a lot.

- Marshall
 
this will do it (i think if i understand correctly)

<pre>
for each transaction
no-lock
break by bin_location
by product_number:
accumulate transaction.any_field (count by product_number).
if last-of(product_number) then
disp bin_location product_number (Accum count by product_number transaction.any_field).
end.
</pre>
 
You must log in or register to reply here.
Back
Top