Using Excel functions from within Access

O

opeyemi1

Hello everyone:
I posted this earlier, but I think I posted it in the wrong forum.
I have the following query set up and it works well so far:

SELECT Count([B&B No Negatives and Processing Time].[Processing Time]
AS [CountOfProcessing Time], Min([B&B No Negatives and Processin
Time].[Processing Time]) AS [MinOfProcessing Time], Max([B&B N
Negatives and Processing Time].[Processing Time]) AS [MaxOfProcessin
Time], Avg([B&B No Negatives and Processing Time].[Processing Time]) A
[AvgOfProcessing Time]
FROM [B&B No Negatives and Processing Time]

I have 2 other fields ([Pay] and [Total Check Amount], that I woul
like to add to the criteria for this query, such that when the query i
finding the Count, Min, Max and Avg of the Processing time it shoul
IGNORE instances when a row has Pay AND the Total Check Amount is les
than 250000 only. Therefore, it should find the count, min, max and av
based on the remainder. In the Pay field, some rows have pay, some ar
blank and some have N/As. I want the query to consider all these, an
not ignore the blank rows for example.

Please please help, this is urgent.


thank
 
Top