Query question!

[Bob Vance]

LastName(Text) and ClientID(Number)
Are say 2 fields in my query how can I get the expression in Uppercase
First 3 characters in LastName & OwnerID
to get something like SMI45

 

[John W. Vinson]

LastName(Text) and ClientID(Number)
Are say 2 fields in my query how can I get the expression in Uppercase
First 3 characters in LastName & OwnerID
to get something like SMI45

An answer:

UCase(Left([LastName], 3) & OwnerID

The question:

WHY on earth would you want this?

It's redundant. It's no more unique than the OwnerID already is. It's not
mnemonic (is SMI34 or SMI127 Janet Smith?) It's an "intelligent key" (and no,
that's not a compliment, unfortunately).

It's easy to create this... but what use will it serve?

 

[Bob Vance]

Thanks John, its a unique bank code given to my clients for a bank reference
on a statement, the first 3 letters gives you a heads up who it is but the
individual ID number is final, hmm what about say "St George Club" Would I
get STG I was going to use this in my query too =UCase .........Regards Bob

LastName(Text) and ClientID(Number)
Are say 2 fields in my query how can I get the expression in Uppercase
First 3 characters in LastName & OwnerID
to get something like SMI45

An answer:

UCase(Left([LastName], 3) & OwnerID

The question:

WHY on earth would you want this?

It's redundant. It's no more unique than the OwnerID already is. It's not
mnemonic (is SMI34 or SMI127 Janet Smith?) It's an "intelligent key" (and
no,
that's not a compliment, unfortunately).

It's easy to create this... but what use will it serve?

 

[Bob Vance]

This works except for St George
BankCode: Left([OwnerLastName],3) & [OwnerID]
Thanks Bob

Thanks John, its a unique bank code given to my clients for a bank
reference on a statement, the first 3 letters gives you a heads up who it
is but the individual ID number is final, hmm what about say "St George
Club" Would I get STG I was going to use this in my query too =UCase
.........Regards Bob

LastName(Text) and ClientID(Number)
Are say 2 fields in my query how can I get the expression in Uppercase
First 3 characters in LastName & OwnerID
to get something like SMI45

An answer:

UCase(Left([LastName], 3) & OwnerID

The question:

WHY on earth would you want this?

It's redundant. It's no more unique than the OwnerID already is. It's not
mnemonic (is SMI34 or SMI127 Janet Smith?) It's an "intelligent key" (and
no,
that's not a compliment, unfortunately).

It's easy to create this... but what use will it serve?

 

[Maarkr]

UCase(Left(replace([OwnerLastName], " ",""), 3))

This works except for St George
BankCode: Left([OwnerLastName],3) & [OwnerID]
Thanks Bob

Thanks John, its a unique bank code given to my clients for a bank
reference on a statement, the first 3 letters gives you a heads up who it
is but the individual ID number is final, hmm what about say "St George
Club" Would I get STG I was going to use this in my query too =UCase
.........Regards Bob

LastName(Text) and ClientID(Number)
Are say 2 fields in my query how can I get the expression in Uppercase
First 3 characters in LastName & OwnerID
to get something like SMI45

An answer:

UCase(Left([LastName], 3) & OwnerID

The question:

WHY on earth would you want this?

It's redundant. It's no more unique than the OwnerID already is. It's not
mnemonic (is SMI34 or SMI127 Janet Smith?) It's an "intelligent key" (and
no,
that's not a compliment, unfortunately).

It's easy to create this... but what use will it serve?

.

 

[Bob Vance]

Brilliant Mark thanks for the help
Regards Bob

NameCode: UCase(Left(Replace([OwnerLastName]," ",""),3)) & [OwnerID]

UCase(Left(replace([OwnerLastName], " ",""), 3))

This works except for St George
BankCode: Left([OwnerLastName],3) & [OwnerID]
Thanks Bob

Thanks John, its a unique bank code given to my clients for a bank
reference on a statement, the first 3 letters gives you a heads up who
it
is but the individual ID number is final, hmm what about say "St George
Club" Would I get STG I was going to use this in my query too =UCase
.........Regards Bob

LastName(Text) and ClientID(Number)
Are say 2 fields in my query how can I get the expression in Uppercase
First 3 characters in LastName & OwnerID
to get something like SMI45

An answer:

UCase(Left([LastName], 3) & OwnerID

The question:

WHY on earth would you want this?

It's redundant. It's no more unique than the OwnerID already is. It's
not
mnemonic (is SMI34 or SMI127 Janet Smith?) It's an "intelligent key"
(and
no,
that's not a compliment, unfortunately).

It's easy to create this... but what use will it serve?

.