Queries in VBA

[j_Southern]

I have another problem with generating queries in code
I get a SQL syntax error which I have narrowed down to the last addition to the SQL string (marked with*)

Please Login or Register  to view this content.

I get confused with the quote marks and i expect theses are wrong, but I have not been able to see how.
Can anyone help please
John

[Chippy]

Quotes were ok - use Chr(34) instead of "" if you find the latter difficult to read. MsgBox strSQL also helps to see the string generated.

The problem was mismatching parentheses. Try the last 2 lines as:

Please Login or Register  to view this content.

[j_Southern]

Hi Chippy,
It seems that the mismatched parenthases were not the only problem.
There does still seem to be something wrong with the date criterion line.
This code works

Please Login or Register  to view this content.

The parenthases in the remed out lines are not the same as yours because I had tried several versions before looking at the last criterion line again.
With reference to the parantheses, do I actualy need them? None of the criteria are nested, they are all of the same level of"importance"
The brackets are only there because I originaly copied the lines from the SQL statement in MSQuery.
John

[j_Southern]

Chippy (and others)
Please don't waste any more time on this problem.
There was nothing wrong with the date criterion except that StartD was empty due to an earlier typo.
All is working now.
Thanks very much for your help on the paranthases though, they definitely did need sorting.
John