Results 1 to 2 of 2
  1. #1
    klparham is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    1

    After Update, filter subsequent notifications on customer ID

    I have an issue tracking database (2016) that receives daily open issue notifications from a SAS program. If an issue will take several days to resolve, then service tech will change status to 'Wait'. However, SAS will send the issue to the table everyday until actually resolved. How could I suppress/filter out (say for 2-3 days) the subsequent daily notifications in the issue form for a specific customer ID? I was thinking of adding a macro to 'After Update' in the status field, but I'm not sure what that would entail. Thanks for any advice.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    have SAS send to a 'temp' table,
    then a query to join the main data to temp and exclude the 'wait' records, but import the others.

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

Similar Threads

  1. Filter Customer Phone
    By tehvilinaty in forum Access
    Replies: 1
    Last Post: 06-04-2018, 12:56 PM
  2. Replies: 3
    Last Post: 03-09-2018, 05:32 PM
  3. Update query running notifications
    By Esmatullaharifi in forum Queries
    Replies: 2
    Last Post: 04-07-2015, 07:34 AM
  4. Replies: 6
    Last Post: 12-11-2013, 09:27 PM
  5. Replies: 7
    Last Post: 11-01-2013, 03:17 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
  •  
Other Forums: Microsoft Office Forums