Search results

  1. A

    iif statement in a query used for criteria

    Thank you both for your help My query in SQL View looks like this (I hope this is what you meant): SELECT Main.PermitNumber, Main.PERM, Main.PermitType, Main.Status, Main.DateOfEnquiry, Main.DateFormsSent, Main.CompanyName, Main.CompanyBuildingNameOrNumber, Main.CompanyStreet...
  2. A

    iif statement in a query used for criteria

    Could somebody help me please? I have a database for case files, with a search form containing various text boxes that lets you enter criteria for the search so that when you click the search button, the results are displayed in a report. However I would like to add a tick box on the search...
Back
Top Bottom