group by on data block
abcdxyzNov 18 2010 — edited Nov 18 2010Hi all
sorry for troubling u frequently actually i am in a firefighting mode and the deadline of the forms is by weekend and i am relatively new to forms
i have a summary block on which i want to use a where clause where there is a group by
the summary data block consists of 4 columns
order_number,part_number,status,quantity
i want to display the records based on the sum(quantity)
basically
select order_number,part_number,status,sum(quantity)
from summary
where order_number = order number from the control block form
and part number =part number from the control block form
and status = status from the control block form
group by order_number,part_number,status
is it possible to write my where clause as
where order_number = order number from the control block form
and part number =part number from the control block form
and status = status from the control block form
group by order_number,part_number,status
and if yes where do i specify the sum(quantity)
please help me
thanks a lot for your help you are providing me
thanks
satish