Hey guys!
I have an issue I cant seem to resolve.
I am running a query where an excel report will pull agent data from an access database into an excel table. I need it to filter out agents that have a term date older than 90 days. My term date column in access is [TERM_DATE] and it is set to Short Date format. So in the query, I have it check a bunch of other parameters that works fine such as MU_ID, AGENT_NAME etc.
Here is my SQL query:
The results of this query: it only pulls agents to have a term date set in the database that is not older than 90 days and excludes all the other agents that have a null/blank [TERM_DATE]. When I add the 'OR Is Null' to the query:
It ignores ALL the other parameters and pulls all 500 agents who have a null [TERM_DATE]
So, in summary, I cannot get the SQL query to Access to filter out agents who have a [TERM_DATE] older than 90 days while still filtering the other parameters and still pulling agents who have a null/blank [TERM_DATE]
While trying to fix this I noticed that my [TERM_DATE] column was text. So I changed it to short date instead and now my second problem is, my update macro gives me an expression error on the date. Here is my code:
So really, 2 issues. I cant filter results and I cant update my database.
Bookmarks