I am experiencing problems with the dynamic query and am hoping I can get another set of eyes on this. Or perhaps this is a limitation of Access in which case I could use some fresh ideas.
With much help from this forum I have a set of 3 related queries that give me the data I need to fill some of my reports. The problem is that when I try to join the last or final of my 3 queries (the one with all the data) with the 'Where' statement of my dynamic query it fails.
It prompts me to enter MaxofUpdateDate which was an alias I used in the 1st and 2nd of my 3 queries. It's like it is not performing the 'deeper' query to find the value so it is prompting me for it. Unless I am missing something which is entirely possible.
I have attached the pertinent part of the database so please take a look and let me know what you think.
I am using Access 2002 on XP but have saved the DB as Access 2000
Thank You!
With much help from this forum I have a set of 3 related queries that give me the data I need to fill some of my reports. The problem is that when I try to join the last or final of my 3 queries (the one with all the data) with the 'Where' statement of my dynamic query it fails.
It prompts me to enter MaxofUpdateDate which was an alias I used in the 1st and 2nd of my 3 queries. It's like it is not performing the 'deeper' query to find the value so it is prompting me for it. Unless I am missing something which is entirely possible.
I have attached the pertinent part of the database so please take a look and let me know what you think.
I am using Access 2002 on XP but have saved the DB as Access 2000
Thank You!
