long query string

P

PF

Hi all,

I have the following table

tbldat
====
prod product number
qsend qty send
qreceipt qty receipt
date date send

the same prod can have more than one entry each day

If i want to display the data by month
what kind of instruction should i use?
What is the best way
i want
prod,qsend jan, qreceipt jan, qsend fev, qreceipt fev,.... ,qsend dec,
qreceipt dec

regards
pierre
 
Top