I have a form that is run by a query. What the query does is take a date from the form, and returns a date that is the end of the month, one year, three years and five years hence. I use dateadd() three times to get the new dates.
The query runs fine. It gives me the three correct dates. But when I run the form I get 'This expression is typed incorrectly or is too complex to be evaluated."
I tried moving part of my query to a sub query. It still runs fine, but still will not run from the form.
What can be the matter? I am scratching my head on this one.
Robert
The query runs fine. It gives me the three correct dates. But when I run the form I get 'This expression is typed incorrectly or is too complex to be evaluated."
I tried moving part of my query to a sub query. It still runs fine, but still will not run from the form.
What can be the matter? I am scratching my head on this one.
Robert
