hi,
i have 3 tables (clothes, employee and order) in an access db
they have the following attributes (they have more but these are all u need i thought)
clothes: [u]clothid</u>, description, price
employee: [u]employeeId</u>, location
Order: [u]orderid</u>, employeeid, clothid, totalAmount, totalPieces
now i wanna generate a report which is first sorted on location, within that it must be sorted on clothes.description
But when i have multiple orders for the same clothesid i'm getting also more rows for this piece of clothing in my report. All i want is the total per cloth.
I already tried some things with distinct and distinctrow...but somehow that stupid access ain't doing what i want it to do
i hope the text above made sense to anyone...:)