I'm having trouble with a query that used to work but recently decided to stop working even though it hasn't been modified. I'm receiving the error "This expression is typed incorrectly, or it is too complex to be evaluated." and I determined that it's coming from my DateValue criteria. I'm confused as to why this is happening though.
SELECT qryFinalizedStartDate.QuoteNumber, qryFinalizedStartDate.QuoteDesc, qryFinalizedStartDate.CustomerName, qryFinalizedStartDate.DraftedBy, qryFinalizedStartDate.PricingReviewedBy, qryFinalizedStartDate.QuoteReviewedBy, qryFinalizedStartDate.DateReceived, qryFinalizedStartDate.DateQuoteSent, [DateQuoteSent]-[DateReceived]+1 AS TurnaroundTime
WHERE (((DateValue([DateQuoteSent]))<=DateValue([Enter an End Date])));
Basically it's just a query used to select a date range between two different date fields. In the original query I use >=DateValue for my DateReceived field which works fine. The second query uses <=DateValue for my DateSent field and that's where the issue lies.