Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2011
    Posts
    3

    Unanswered: Help with queries?

    Im fairly new to access,
    am running access 2007, and i want to create a query that will look up a field i have in my accident report table called "manager informed" the manager informed data type is set to yes/no, and i want the query to look at this field and display the data from this field that has not been selecetd. (the box has not been ticked)

    any help is greatly apprectciated, many thanks!

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    If I correctly understand what you want, it should be something like:
    Code:
    SELECT * FROM [Accident Report Table] WHERE [Accident Report Table].[manager informed] = False;
    I don't know what the actual name of the table is, though.
    Have a nice day!

  3. #3
    Join Date
    Apr 2011
    Posts
    3

    query

    thanks for the quick reply,
    i dont want a messege box to open upon running the query i just want it to search the table and display the the field under informed manger that have not had a tick in the box on the table.
    many thanks

    when i entered the code you gave me a messge box appeard sayin the following enter paramter value:
    Accident Report TBL.Manager Informed

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You have to adapt the code I provided to match the name of your table and the names of its columns. If there are spaces in one or several of those names, they must be enclosed between square brackets: [one name]
    Have a nice day!

  5. #5
    Join Date
    Apr 2011
    Posts
    3

    Thanks

    thanks for the help, i ended up doing it in design view by adding the tables and then in the parent infomed field critria i just enetered =false and it displays what i required, many thanks for your help

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •