Past Due Query

[SideOiler]

Hello everyone,
I am trying to create a query that produces results that are only past due but have been unsuccessful thus far. The query has a Entered Date field, a Review Due Date field, and a QA Date field. The form that this query is attached to automatically sets the Review Due Date 5 days out from the Entered Date. The QA representative is suppose to review and approve the documents within those 5 days. I want to be able to search a date range so in the Entered Date field, on the criteria line I have Between [StartDate] And [EndDate], which works as intended. however I can not get the report to only provide data for those documents where the QA date is greater than the 5 day Review Due Date. I either get everything in the Table or a Few random results that don't necessary fit into the criteria I am looking for...
Does anyone have any ideas that will keep me from banging my head on the desk...:banghead:

Thank You,

Chris

 

[CJ_London]

if you open the thread and look to the bottom you will find a number of threads addressing your problem.

 

[SideOiler]

CJ London, I dont quite understand how to adopt these into my query. A lot of what I see in those threads is Greek to me. Do you have any other advise?

Thanks
Chris

 

[CJ_London]

Learn Greek The lack of detail on you question won't enable me to provide an any more detailed answer.

If you want specific help with your specific situation, please provide a lot more information such as full details of all tables involved (tablename, field names/types) any relevant relationships.

Then for your form, the details of the recordsource and the relevant controls referenced by the query plus how you want to display the results

And for your query, the full SQL

 

[AlexN]

What's wrong with Greek guys?


Good luck with your issue SideOiler
I'm sure CJ is in charge