Results 1 to 2 of 2
  1. #1
    denis.m is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    2

    Update Multiple fields according multiple criterias

    I am creating a reporting tool which aggregates late dates and displays under which group the data is.

    To explain, I have a list of items with dates and delays. I want to create a formula in VBA or SQL to update fields when the date is or "deadline + 5" or "deadline + 10" and so...
    In that case, the propreties of the item are: Item Ref (text), Date Received (Date), Deadline + 5 (Yes/No), Deadline + 10 (Yes/No).

    I am stuck to add criteria to my formula.



    Thank you in advance.

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    I'm not quite sure I understand what you need. You have a date received and you have a deadline. Is deadline another date field in your table? How are the +5 or +10 determined? Can you provide more details of your table structure (table/field names and relations if multiple tables are involved)?

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

Similar Threads

  1. Replies: 15
    Last Post: 10-14-2010, 12:22 PM
  2. Replies: 4
    Last Post: 09-22-2010, 01:47 AM
  3. multiple dcount update query
    By slothnet in forum Programming
    Replies: 5
    Last Post: 08-24-2010, 03:44 PM
  4. Replies: 1
    Last Post: 02-03-2010, 09:17 PM
  5. Replies: 1
    Last Post: 12-10-2009, 08:41 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