Search results

  1. B

    Access SQL Seq Numbering

    Need to number a group of records( Focus_Group field/ Date ascending/ Tail is the value) SeqN should be 1,2,3,etc This works in another database same sql!! All I get here is "1's"! SELECT Defer_sorted.Focus_Group, Defer_sorted.Created_Date, Defer_sorted.Tail, (SELECT Count(*) FROM Defer_sorted...
  2. B

    Iif with 2 different sum formulas

    Doing a simple group query, unfortunately "Duration" field has 2 different values minutes or hours. Want one value in the end "Hours". If Payment Group = X then they need to be treated as Hours. All others in Payment Group need are Minutes and converted to hours(divide by 60)...
Back
Top Bottom