Select query to obtain records of different depts

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.
 
M

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting data of different Depts from a table 1
Query to select values after a certain date 0
End of Month: Parameter Query? 3
Losing Records Between Union Query and Select Query 3
Select Query & Crosstab Query 1
Create a string from a query result to add into sendObject 2
Update Query Finds Different Number of Records Than Select Query 2
Apply curve to results of query 3

Top