Customer Ref

[Chrisopia]

Right, it's starting to bug me. I am getting somewhere at last.

I have tried a different approach which seems to be working thus far - I just need 2 more things then it will be complete!!!!

I have attached a sample I am working on to get this stupid thing working,

As you can see it can happily read the First three letters of either the company name or the last name
I used this simple code:

LeftName: UCase(IIf([Company Name] Is Null,Left([Last Name],3),Left([Company Name],3)))

Basically it looks if the company name is empty then display the first 3 letters of the last name, otherwise display the first three letters of the company name.

All I have to do now is count up, with extra 0's infront:

BUR ---> BUR001
CAR ---> CAR001
BUR ---> BUR002
GRE ---> GRE001
GRE ---> GRE002
DER ---> DER001
CAR ---> CAR002


Hope this makes sense?

 

[Brianwarnock]

All I have to do now is count up, with extra 0's infront:

OK you have done the simple bit now you want somebody to write the code to do the other bit, is that correct?

BTW you said that there were 2 things , what is the other?

Brian

 

[Chrisopia]

It was the simple bit and I dont want someone to WRITE the code, I just need guidance, afterall I wont learn anything if someone does all the work for me.

2 parts - counting and adding the extra zero's