Recent content by bradgerb

i have a table that has a field called prefix and the first number is 00765 (stored as text) is there a way to have the next record in the table be 00766 and so on? This way I don't have to type that new number everytime in the table. its always +1 from the previous thanks Brad

CJ that worked thank you thank you thank you!!

Hi and thank you for taking the time to help out. I am trying to build an expression that has multiple IIF then needs and I don't even know if its possible I can get it to work with one expression Pack Day:IIF([dayid]=1,"Tuesday","") works fine but here is where I need help how do I do it with...