>Hi,
>
>I have a two tables, cust.dbf and job.dbf. They are linked by the cust_no field. The job table has a field called Priority which can have three values: 1, 2 or 3.
>
>I want to pull a report which will show the customer's cust_no, name, and then 3 other columns called Priority1, Priority2, priority3. Priority1 would be the total # of 1's, Priority2 would be # of 2's and Priority3 would be the number of 3's (for each customer).
>
>Can this be done *quickly* with an sql statement?
>
>Thanks in advance. -Rick

easiest way would be to group report by cust_no and sum 3 vars (one for 1, 2, 3) to print in the group footer.