Results 1 to 2 of 2
  1. #1
    Delta729 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Los Angeles
    Posts
    95

    Append query from multiple null fields

    Sorry, title should have said update query... I noticed after the initial post.



    I have a database and I'm using an update query to add the word "Exclude" into the Exclude field if the date is missing. This is simple enough for say, if "Submitted Date" is empty, update the word exclude to Exclude field. Right now I'm running four separate a update queries because I've never been able to figure out how to make it work on multiple fields.

    I have "Last Date Worked", "Submitted Date", "Validated Date", & "Invoiced Date". If any are empty I need to add the word Exclude to the Exclude field. I'm a novice with Access. I'm learning by doing. I haven't written anything with Sql, I've just created the queries I've used through the query creator.

    Any help would be greatly appreciated.

  2. #2
    Delta729 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Los Angeles
    Posts
    95
    Disregard... I've figured it out. I've split out the additional date fields onto separate or rows. I always though the first OR row was or for all other columns, but I guess if all on the same row, it would only work if both date fields were empty.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 11-09-2012, 08:17 AM
  2. Is Not Null...Multiple fields
    By msk7777 in forum Access
    Replies: 13
    Last Post: 11-17-2011, 02:52 PM
  3. Replies: 2
    Last Post: 11-16-2011, 07:38 PM
  4. Query Not Returning Null Fields
    By mgmirvine in forum Queries
    Replies: 2
    Last Post: 10-28-2011, 06:15 PM
  5. append query for multiple databases
    By vasto in forum Access
    Replies: 0
    Last Post: 09-24-2009, 08:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums