Hi all,
I have a mysql query which I have written and then pasted into the SQL window of MSQuery - the query works well and gives me the result that I need.
What I would like to do is develop the solution further so that the user can input a date and have that flow through to the query via vba (or another method if anyone can suggest one).
I have done this before with quite small simple queries but this particular one is very lengthy and I seem to have some up against some sort of maximum query length inside the vba code. The message I get is something about too many line continuations.
Can anyone shed some light on how I might be able to solve this??
Many thanks.
Bookmarks