var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Distinct Rows Query issue
I have query that 3 columns, the first is the productNo, Description and Type.
I am trying to get distinct ProductNo. but I am unable to because, Description is either spelled in all CAPS or as some other minor things.
What I am trying to do is get the first Distinct ProductNo and have one of the Descpriptions displayed.
Create a "totals" query by pressing the button that looks like a greek E. Select "Group By" for the ProductNo and "First" for Description.