Fordraiders
asked on
distinct query on 2 fields but keep field order in tact
Access 2010
I have a query that i need to have 2 distinct fields:
alt_acc_comp_score.MATERIA L_NO
alt_acc_comp_score.ALT_ACC _MATERIAL_ NO
but i need the fields in this order
Thanks
fordraiders
I have a query that i need to have 2 distinct fields:
alt_acc_comp_score.MATERIA
alt_acc_comp_score.ALT_ACC
but i need the fields in this order
SELECT DISTINCT alt_acc_comp_score.MATERIAL_NO, main_xref_t1_2.WWGSlsStatus, alt_acc_comp_score.ALT_ACC_MATERIAL_NO, main_xref_t1_2.WWGShortDesc, main_xref_t1_2.WWGMfrNum, main_xref_t1_2.WWGVdrBrandName, main_xref_t1_2.WWGSlsStatus, main_xref_t1_2.WWGCatalogPgNo, main_xref_t1_2.WWGUOM, main_xref_t1_2.WWGUOMQty, main_xref_t1_2.WWGGreen, main_xref_t1_2.WWGExclBrand, main_xref_t1_2.WWGPrice, main_xref_t1_2.WWGCountry, main_xref_t1_2.XRefType, main_xref_t1_2.XRef_Comment, main_xref_t1_2.WWGLongDesc, alt_acc_comp_score.comp_score
FROM alt_acc_comp_score INNER JOIN main_xref_t1_2 ON alt_acc_comp_score.ALT_ACC_MATERIAL_NO = main_xref_t1_2.WWGSKU
WHERE (((alt_acc_comp_score.MATERIAL_NO)="2a234"))
ORDER BY alt_acc_comp_score.MATERIAL_NO, alt_acc_comp_score.comp_score DESC;
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ok, but there was no rush, ...you could have waited to see if another expert could have provided a more complete solution...
;-)
Jeff
;-)
Jeff
ASKER