Union Query Help

[pmp]

Can someone please tell me why I am getting a syntax error for this query?



I am not a geek in access but I know that this query can also be broken up, please assist me with completing either task:

1. Running the current query
2. Breaking the query into months/quarters

I've attached the query in notepad for ease of use.

[June7]

What is the exact error message?

That query is too much to try to read through. Did you test each SELECT query individually in Access query designer?

[pmp]

Thanks so much for taking the time to read my issue and respond. I am getting a syntax error. No I have not tested each aspect of the query. Reviewing the query can you assist me with determining how to break the query up for testing. I tried but it said my statement was incomplete. I wrote it from SQL and I am new to both SQL and Access.

I agree, the query is too much I just recieved it from another department but don't have a clue how to execute or trouble shoot the error.

Again, thanks!

PMP

[June7]

Use the Access query designer to build and test SELECT query. I have always switched to SQL View to type in the DISTINCT keyword but just realized this can be selected in the Property Sheet dialog. It is Unique Values property.

You can copy/paste into SQL View any of the nested SELECT statements from the UNION.

Assumes you have the relevant tables either in your project or links to them.

You say it gives a syntax error message but what is the EXACT full message?

[pmp]

Thanks! I am in the process of doing the queries and will let you know my progress.