Search results

  1. B

    Access SQL Seq Numbering

    Everyone many THANKS!!! Will review to see what I missed
  2. B

    Access SQL Seq Numbering

    Took the Date out of the SQL just now and still get "1's". My thinking is that I need to tell it to group by Focus_Group but don't want to group by Tail, as that's a value.
  3. B

    Access SQL Seq Numbering

    Paul, It was originally Date and Time. I past it through to another table as "Short Date". Really don't need "Date or Time" for this exercise. We just want each Focus Group to have the SeqN 1,2,3 numbering and Tail (value). thanks Bernie
  4. 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...
  5. B

    Iif with 2 different sum formulas

    EternalMrytle, you win the prize!! Pymnt_Group wasn't included..... Thank you Happy holidays
  6. B

    Iif with 2 different sum formulas

    Thanks.. 0001Initial_Extract_OT is the table Pymt_Group is the field The format was generated by the Expresiion builder I'm getting the warning that I'm expression as part of an aggragate function
  7. 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