View Single Post
  #1  
Old August 12th, 2004, 11:18 AM
external usenet poster
 
Posts: n/a
Default Select query to obtain records of different depts

Hello,

I have a select query that retrieves information from four
different departments.How would i set the criteria to
separate the info obtained from these four departments and
get a summ total for each since my current results are all
departments together.Is it possible to even skip a row
between depts?The depts would be like
Marketing,Sales,Finance,Accounting.

Thanks for any assistance.