How to return data specific to employee & customer & a range of days less than the project end date

[Joe1970]

I have a form for tracking various dates when an employee completes a segment of the project. I want to be able to run a query that will return only data specific to the employee responsible for that segment if they have not entered a completion date and that segment falls in number of days (preferable a range) that is less than the project completion date.



For example: Project completion date 12/31/19

Employee Customer Project Segment Project Segment Completed

Joe Tulsa 1st Meeting Docs (field is blank, no date entered)

I am new to Access so I apologize in advance if this has been answered previously. Ultimately my goal is to set this up so the employee gets an e-mail reminder through Outlook via Office 365

Thank you!

[pbaldy]

The lack of replies probably indicates there isn't enough info to give an answer. What is your table structure, or can you attach the db here? It's easy enough to add a criteria to a query that gets data within a given date range. That range can be selected by the user or be relative to "today", like anything in the next 30 days. It should also be easy to add a criteria to limit data to a specified employee, presuming there's a field for employee in the data.

[Joe1970]

The lack of replies probably indicates there isn't enough info to give an answer. What is your table structure, or can you attach the db here? It's easy enough to add a criteria to a query that gets data within a given date range. That range can be selected by the user or be relative to "today", like anything in the next 30 days. It should also be easy to add a criteria to limit data to a specified employee, presuming there's a field for employee in the data.

There are tables in Access for all of the information needed. I just can't seem to write the code. You are correct with respect to what I am trying to do as far as date and employee. I tried to upload the Access file with the tables and form, but it is to big at 2.98KB. any help would e greatly appreciated.

[pbaldy]

Try doing a compact/repair and then zipping it.

[Joe1970]

Cool, That worked