5 Replies Latest reply: Dec 22, 2017 5:19 PM by Rob Wunderlich RSS

    Autonumber not working ?

    Steven Stocki

      Blown away at what I am doing wrong.


      Trying to get an "AutoNumber" for Name and SpecialtyDMis.. but yet it acts as if the SpecialtyDMis doesn't exist ?


      Any ideas? Thanks


      Example fake data below.




      Autonumber(Name2,SpecialtyDMis) as [HighestDMisSpecialty]

      Resident [SurgeonUpdate2]

      Order by Name2,Count Desc;

      Drop table [SurgeonUpdate2];