Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
[SurgeonUpdate3]:
load*,
Autonumber(Name2,SpecialtyDMis) as [HighestDMisSpecialty]
Resident [SurgeonUpdate2]
Order by Name2,Count Desc;
Drop table [SurgeonUpdate2];
Hi,
My mistakle, please use this: autonumber(Name2&'-'&SpecialtyDMis,Name2)
Hi,
Please try autonumber(Recno(),Name2&'-'&SpecialtyDMis)
Cheers,
Luis
Hi Luis,
Tried but it didn't work.
I think the first fieldname in the bracket is what is used to reset the count for each name - rowno() will always be different so it'll always give a ranking of 1.
Hi,
My mistakle, please use this: autonumber(Name2&'-'&SpecialtyDMis,Name2)
argh it was the second field ! Thanks !
Your code should be:
Autonumber(SpecialtyDMis, Name2)
Number each new value of SpecialtyDMis and reset the counter for each new Name2.
-Rob