Search results

Everyone many THANKS!!! Will review to see what I missed

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.

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

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...

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

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

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)...