Recent content by ianclaridge

  1. I

    MS Access SQL Error Adding a static value via UNION to a SELECT Distinct Query

    The penny just dropped thanks, I had assumed the static value didn't have a source and that adding one would cause an error! SELECT "All" As Status FROM table1 UNION SELECT Distinct table1.Status As Status FROM table1 works thanks and apologies for missing that within your reply!
  2. I

    MS Access SQL Error Adding a static value via UNION to a SELECT Distinct Query

    Thanks but that part isn't from a table, it's just a value, like this.. ... and similarly the other side of the query works fine standalone... ...but if I UNION them.. Do you see what I mean?
  3. I

    MS Access SQL Error Adding a static value via UNION to a SELECT Distinct Query

    I have a simple form based on a table for unskilled users to view and filter data using a combo box. Hence I simply want to add the the option "All" to the SELECT distinct query for values in that field but am encountering "unexpected error evaluating complex query". Here is my code...
See more
Back
Top Bottom