For the Past few days I have been trying to create Query, and
everyone I have asked have been obtuse with the help. I am a new to
access and still learning, so it is probably that stops me from
understanding.
What I want - I have a query that is designed to display task
deadlines to the user. It should display all the deadlines that are
due in, over the next 2 weeks. The deadlineDate is made up of
Days/Months/Year, then along with that, there was a task name and
brief description of the task. What should then happen is when the
query is run, it will check the current date on the computer, then
compare that date to all the deadlineDate's. Then if any of those
dates are 14 days or less to the current date, it will display those
tasks. Deadlines that have past should not be displayed!!!
What I did was create all the fields, which was no problem. Then
under the deadlineDate in the criteria section I put;
"<=Date()+14"
But the data that is displayed is not what I want. Some of the data
displayed was wrong by 2 months!!!
Can anyone help me???
Richard