Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2014

    Unanswered: Access 2007 - Exclude columns that have blank field in a report

    I'm currently trying to complete a database in access 2007 for my training section. My current issue is when trying to look to see who has what classes by using a report i get all students.

    My report only has Last name, First name, age, office symbol, course title.

    Im trying to make it so when i bring up the report it only list those students that have a date under course title.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    You'll need to provide more info and be more precise. I cannot figure out how a column that is named [course title] can contain Date/Time values. Please post the data structure (name, columns names and data type) of the table(s) involved.
    Have a nice day!

  3. #3
    Join Date
    Apr 2014
    Provided Answers: 34
    Select * from tbl where [course title] is not null

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