Search results

  1. Y

    qurey and null values

    Hello Looking to get some help with a query I am doing I am using Like "*" & [forms]![myform]![myformfield] & "*" Or Is Null in my Criteria field of the query, to try and get the form to display records that have blank fields but it will only display fields that have all the fields filled out...
  2. Y

    Query wont pull up a blank field

    Hello I am running a query with Like "*" & [forms]![Frm_Lock_DES]![LNumber] & "*" in the Criteria field. This links it to the form which returns all the records that have all values in them, For example 1st name,last name, email etc. But if a record has a blank field it will not return...
  3. Y

    Search query to a report

    I was wondering how do you get the the search results of a query to display on a pre set report, by clicking on a button on a form ? Any and all help would be greatly appericated.
  4. Y

    Search Form help on a Search form

    Hello I am new to Access, but I am currently working on a small database in one of the local college to keep track of all the lockers in the building. Now the way it works is the user will enter the search criteria data into a form, then that data is sent to the query which searches for...
Back
Top Bottom