Expression typed incorrectly or too complex?

F

FBxiii

I have a query that uses a function to calculate the number of working days
between 2 dates. The query works fine and returns the number of days.

I am using the query to get a count of records 'cleared' in over 10 days.
When I put a criteria under the calculated field to determine any records
over 10 days, I get an error saying "The expression is typed incorrectly or
is too complex to be evaluated".

Here is the SQL:
SELECT zREP_SAR_Files_Received_by_Date.Submitting_SSC,
Count(tblSAR_Tracker.MPR) AS CountOfMPR
FROM zREP_SAR_Files_Received_by_Date INNER JOIN tblSAR_Tracker ON
zREP_SAR_Files_Received_by_Date.File_Name = tblSAR_Tracker.File_Name
WHERE (((calculate_working_days([Received_Date],[Cleared_Date]))>10))
GROUP BY zREP_SAR_Files_Received_by_Date.Submitting_SSC;

Can anyone see what I am doing wrong?

Cheers,
Steve.
 

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

Updateable Query 5
Need Help with Totals Query 24
need help with expression 4
Too complex 5
ACCESS query expression that works on one computer but not another 4
expression typed incorretly or too complex to be evaluated 6
formula in query criteria 2
Complex Count Query 0

Top