Select query to obtain records of different depts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi,


Have you tried a total query? In the query designer, click on the summation
button, the one with a capital Sigma, a kind of M rotated by 90 degree, and
a new line, Total, appear in the grid. Drag the field Department in the
grid, keep the proposed GroupBy. Drag the field with the data to be summed,
in the grid, change the GroupBy to Sum. If you wish to applied a criteria
before that the summation occur, drag the field, in the grid, change the
GroupBy to Where, and supply the criteria.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top