Hello All
I have a query that runs perfectly. When I copy the SQL code from it into the click event of a button I get a compile error. The SQL is a bit complex but as i said it runs fine in the query.
SQL...
SELECT Demo.PREFIX, Demo.FNAME, Demo.LNAME, Demo.PREFIX2, Demo.FNAME2, Demo.LNAME2...