Search results

  1. T

    Using Like "*" or is Null in IIF Statement

    That works exactly as I need it!!! Thanks a million!! Took quite a while to reply as my laptop HD decided to die but this is exactly what I was trying to achieve!!! :D:D This Library database was just a sample (couldn't post work data for obvious reasons) so in the context I need it for, a...
  2. T

    Using Like "*" or is Null in IIF Statement

    Thanks again for the assistance Steve but unfortunately this doesn't return the NULL values :(
  3. T

    Using Like "*" or is Null in IIF Statement

    Hi Steve, thanks for the attempt but this checks for NULL values in the BookName on the form whereas i want the criteria passed to be Like "*" or is Null for the Edition By itself it works but it does not inside of the falsepart/truepart of the IIF statement. EDIT: I see I made an error in...
  4. T

    Using Like "*" or is Null in IIF Statement

    Ok let me try to clarify if you look at the form there are two textboxes for user input and a option toggle. What I'm trying to accomplish is a query that will run using criteria selectively based on the toggle. When the user inputs the Book Title but leaves the option unchecked and no input in...
  5. T

    Using Like "*" or is Null in IIF Statement

    Hi I've a problem with trying to use a user input field on a form as a criteria for a query. I've used checkboxes as indicators for the fields that will be used to run the query. The query criteria/syntax works for fields in the table that have no NULL values but for fields that do have NULL...
  6. T

    Hi All

    Hi everyone, Carlisle from Trinidad <waves> Wouldnt call myself a newbie but def not an expert programmer either. I'd fall somewhere in between, maybe 'ExpertNewbie'.
Back
Top Bottom