Glen Walker
New member
- Local time
- Today, 19:12
- Joined
- May 2, 2017
- Messages
- 2
Hello everyone
I am currently running a database at my company, I have only being using access for a few months and am still learning to use it.
I am using Access 2010
I would appreciate help on this query maybe I am missing something simple but I don't see it.
There are front end databases that each user works with and a backend networked one with the tables in. In the tables it records the date when a task was completed, this must then be reviewed by the 15th of the following month and the date it is reviewed is then automatically added to the table.
Both table columns CompletedDate and ReviewDate are formatted as Date/Time. Table name "Notifications"
I am trying to create a query to look up which were reviewed after the due date. To do this I have created a select query inside it I have these calculated fields
RequiredDate: DateAdd("m",1,[CompletedDate])
Due Date: DateSerial(year([RequiredDate]), month([RequiredDate]), 15)
On Time: [Due Date]<[ReviewDate]
If I run it like this it works but shows all of the entries regardless of entered early or not, and I understand that. When I try filtering it I added the criteria of True to the On time field, but as soon as I enter this criteria then it asks me to enter due date.:banghead:So I then tried removing the On time field and added <[ReviewDate] as a criteria under the due date field and I then get prompted to enter the RequiredDate. :banghead:
Thanks
I am currently running a database at my company, I have only being using access for a few months and am still learning to use it.
I am using Access 2010
I would appreciate help on this query maybe I am missing something simple but I don't see it.
There are front end databases that each user works with and a backend networked one with the tables in. In the tables it records the date when a task was completed, this must then be reviewed by the 15th of the following month and the date it is reviewed is then automatically added to the table.
Both table columns CompletedDate and ReviewDate are formatted as Date/Time. Table name "Notifications"
I am trying to create a query to look up which were reviewed after the due date. To do this I have created a select query inside it I have these calculated fields
RequiredDate: DateAdd("m",1,[CompletedDate])
Due Date: DateSerial(year([RequiredDate]), month([RequiredDate]), 15)
On Time: [Due Date]<[ReviewDate]
If I run it like this it works but shows all of the entries regardless of entered early or not, and I understand that. When I try filtering it I added the criteria of True to the On time field, but as soon as I enter this criteria then it asks me to enter due date.:banghead:So I then tried removing the On time field and added <[ReviewDate] as a criteria under the due date field and I then get prompted to enter the RequiredDate. :banghead:
Thanks