Link Query to Table

[Bob]

I have a Query that gives all my Clients the first three letters of there
name and there ID Number I.e. Smi23
Smith, Id No 23
How can I link each individual Client with his unique ID Code, I want them
to appear on the Statement (Report) With there Name and address


Thanks in advance.........Bob Vance

 

[John Vinson]

I have a Query that gives all my Clients the first three letters of there
name and there ID Number I.e. Smi23

If the ID number is unique, what's the point of this?

Smith, Id No 23
How can I link each individual Client with his unique ID Code, I want them
to appear on the Statement (Report) With there Name and address

Create a Query (a different query?) including the client's name, ID
code, and address, and base the Report on this query. I presume that
the Client table contains this information??

Bear in mind - you know your table structure. We don't. I don't in
fact understand what this composite field has to do with your
question.

John W. Vinson[MVP]

 

[Bob]

Sorry John My Clients table does not contain my special Reference Code it is
a Query to make it
refClientCode: Left([OwnerLastName],3) & [OwnerID]
I want to get this code Reference into my Client table so as I can link it
to his statement, Thanks Bob

 

[John Vinson]

Sorry John My Clients table does not contain my special Reference Code it is
a Query to make it
refClientCode: Left([OwnerLastName],3) & [OwnerID]
I want to get this code Reference into my Client table so as I can link it
to his statement, Thanks Bob

Again... this makes no sense to me.

What is the Primary Key of your Clients table?
Does it contain the OwnerID, or a foreign key to the OwnerID?
What do you mean by "to his statement"?
And again - what's the point of making a unique OwnerID "even more
unique" by appending a (nonunique) three letter string to it? What is
this composite supposed to be joined TO?

Note: I've known people with last names Wu, Hu, and Lo. What does your
algorithm do with them?

John W. Vinson[MVP]

 

[Bob]

It is for is a Direct Bank Reference, so when they deposit funds into the
office account they give there unique Id like Smi23 which will appear on
the bank statement, I did try my Lo and got a result Lo44 no gaps
The Owner Id Number in the table is a Auto Number Increment, so if I can get
the Reference into my table I can link to the report which is there
statement to pay the funds, Thanks for you help....Bob

Sorry John My Clients table does not contain my special Reference Code it
is
a Query to make it
refClientCode: Left([OwnerLastName],3) & [OwnerID]
I want to get this code Reference into my Client table so as I can link it
to his statement, Thanks Bob

Again... this makes no sense to me.

What is the Primary Key of your Clients table?
Does it contain the OwnerID, or a foreign key to the OwnerID?
What do you mean by "to his statement"?
And again - what's the point of making a unique OwnerID "even more
unique" by appending a (nonunique) three letter string to it? What is
this composite supposed to be joined TO?

Note: I've known people with last names Wu, Hu, and Lo. What does your
algorithm do with them?

John W. Vinson[MVP]

 

[John Vinson]

It is for is a Direct Bank Reference, so when they deposit funds into the
office account they give there unique Id like Smi23 which will appear on
the bank statement, I did try my Lo and got a result Lo44 no gaps
The Owner Id Number in the table is a Auto Number Increment, so if I can get
the Reference into my table I can link to the report which is there
statement to pay the funds, Thanks for you help....Bob

I'm vaguely getting closer. Let me see if I'm on the right track:

You have two tables of people.
One of them has a (manually generated?) primary key like Smi23.
The other has an Autonumber primary key, completely unrelated to this
name/number key.
You want to link the two tables.

Ok... what information in Dave Smith's record in the one table,
matches up to identical information in David Smith's record in the
other table? Is there ANY way in the second table to tell that this
David Smith is Smi23, as opposed to his uncle David Smith, Smi45?

Please post the relevant fieldnames (the actual Access table
fieldnames please, so we can tell just what you mean) in the two
tables, with some examples of the data in them.


John W. Vinson[MVP]

 

[Bob]

Thanks John, JK worked it out for me and its working Brilliant
In the existing form add a text box and in the Control Source (in the
Properties) to:
=Left([OwnerLastName],3) & [OwnerID]