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