Results 1 to 1 of 1
  1. 09-03-2009, 04:19 PM #1
    Brian62
    Brian62 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2009
    Posts
    147

    Need date when there is notes

    Here is the script I am using. I only want a date to show up when there is information in "notes", otherwise I want the cell empty without filtering any of the records. Is it possible?

    Followup Due: Format(DateAdd("m",2,[Audit Date]),"mm/dd/yy")


    The Table name is: RD Office Study File
    Last edited by Brian62; 09-03-2009 at 04:27 PM. Reason: added more info
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. HELP!!next date query, 7 days from the present date
    By Ushera in forum Queries
    Replies: 2
    Last Post: 07-31-2009, 06:56 AM
  2. Top Date per Date in another table
    By danneedham in forum Queries
    Replies: 1
    Last Post: 05-28-2008, 05:47 PM
  3. Import Lotus Notes address book into a MS Access table.
    By acheo in forum Import/Export Data
    Replies: 0
    Last Post: 02-19-2007, 02:43 PM
  4. Access Date/Time....I need a "generic" date.
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 12:55 PM
  5. Make sure end date is one year greater than start date
    By AimeeK in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums