Recent content by ashchak

  1. A

    Nested Update Query in MS Access

    The context is , there are two tables as mentioned below. Basis the column ID & the date, Just need to update the latest status in another table whether success or failure which ever comes last. Table 1 : Rejection Table 2 : Success ID Rejection Rej_Date ID Succ_Date 1001 No...
  2. A

    Expression Error in IIF statement

    Expr1: IIf(CDate([Weekly_Upload].[Gift Date])>[Transaction_Failed].[Gift Date],"Success","Failure") Getting error in this expression Error : Your Query does not include specified expression as a part of aggregate function.
  3. A

    Nested Update Query in MS Access

    Error : Your Query does not include specified expression as a part of aggregate function.
  4. A

    Nested Update Query in MS Access

    Expr1: IIf(CDate([Weekly_Upload].[Gift Date])>[Transaction_Failed].[Gift Date],"Success","Failure") Getting error in this expression
  5. A

    Nested Update Query in MS Access

    Hi Everyone, i have four field in the database Field 1,Field 2,Field 3,Fields 4 Here Field 3 is subset of Field 2 & Field 2 is subset of Field 1 & Field 4 is Date & rest all fields are Numbers. Now i need to add Field 5 which will be a status where i need to update this basis an update query...
See more
Back
Top Bottom