Sum values of column

N

NeoFax

I need to write an expression that sums the values of a query based on
the date. Here is the query setup:
Helo#(Dbl) Sample: 14701, 14702, 14703...
Hours(Dbl) Sample: 1351.5, 1345.7, 1292.1,...
8-01(Dbl) Sample: 87.3, 88.5, 99.2...
8-02(Dbl) Sample: 87.5, 100, 100,...

So, I would like to make an expression that sums all of say column
8-06 as this is the current month. How would I go about writing this?
 
K

KARL DEWEY

What is your table name? What are your field names?

Post sample data like this --
Field1 Field2 Field3
A 1 2/1/08
B 5 5/4/07
X 3 3/22/08
 

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

IF then SUM 5
Summing totals in columns where some cells have error values 1
Problem with Query Calculation 5
Subquery not integrating to query to display previous sum of quantities 3
sum on date/time from multiple tables 1
Group by date on employeeID 4
Select data and sum by weeks in a month 3
New to SUMPRODUCT .. is there a better way? 1

Top