Big help on Qry

[Pedro]

I have a QRY
Sales_Rep Freq Cust_Name City State Zip

I will like to sort this by Sales_Rep but then show the Cust_Name that
are under a especific FREQ

FREQ=
Biweekly
8
Monthly
N

I will like to show first the cust_name under Biwekly Frequency then
Montly then 8 and finnaly N

B
M
8
N


hope you can give me a hand on this,


thanks

 

[Pedro]

I have a QRY
Sales_Rep    Freq     Cust_Name     City    State    Zip

I will like to sort this by Sales_Rep but then show the Cust_Name that
are under a especific FREQ

FREQ=
Biweekly
8
Monthly
N

I will like to show first the cust_name under Biwekly Frequency then
Montly then 8 and finnaly N

B
M
8
N

hope you can give me a hand on this,

thanks

I will like for this Query pull me all the customer with B FREQ and
space and then those customer with M FREQ and so on....