Big help on Qry

  • Thread starter Thread starter Pedro
  • Start date Start date
P

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 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
Click to expand...

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....
 
Back
Top