Recent content by XanLo

Thank you for this, I amended my query to include the ref in the sub query and it did exactly what I needed. SELECT (Select Count(*) from Full_List As H Where H.Email_Address = Full_List.Email_Address And H.ACCREF + H.ACCREF<= Full_list.ACCREF + Full_List.ACCREF) AS [Assign#], * FROM Full_List...

Hi, Firstly I'm very new to access to apologies if I don't word any of this correctly. I have a set of data in 1 single table that contains email addresses and references. There can be more than 1 reference assigned to an email address and I need to be able to sequentially number them so that...