Search results

  1. Y

    Using Checkboxes to select multiple fields in an iif query

    It's OK, got it working! You had the check variable and the combo variables the wrong way around, made the change and all is working as it should Many thanks for your help! Younger
  2. Y

    Using Checkboxes to select multiple fields in an iif query

    I did make a slight modification to the query, but only to correct a syntax error (there was a space at "check_partner" where there shouldnt have been). The data being fed from the combo boxes comes from the same table that is being queried, so I know that the data exists. However, when the...
  3. Y

    Using Checkboxes to select multiple fields in an iif query

    Hi Pat, Thanks for getting back to me. However the solution you gave me doesn't seem to work (I'm getting no results whatsoever). Any other ideas? Many thanks Younger
  4. Y

    Using Checkboxes to select multiple fields in an iif query

    Sorry, I should have added that each seperate iif works independently of the others, its only when all 3 are there that I have issues Cheers Y
  5. Y

    Using Checkboxes to select multiple fields in an iif query

    Hi all, Firstly, I'm an ex-fulltime access developer who has found himself doing access work again 6 years later; I can't actually believe how much I've forgotten :s Anyway, I've done a search and havn't found anything that can help me so wondered if anyone could give some advice. I have an...
Top Bottom