Look up a value

  • Thread starter Thread starter ake
  • Start date Start date
A

ake

I think my problem is about looking up a value.
I have a table with the following values

Name Initials
Juan dela Cruz JdC
Kate Winslet KW
Manuel Tan MT

I put the initial field in the form as when they created an entry in the
form, their initials would show.
My problem is that when i create report I want their full name to appear
rather than their initials, how would I do that?
 
ake said:
I think my problem is about looking up a value.
I have a table with the following values

Name Initials
Juan dela Cruz JdC
Kate Winslet KW
Manuel Tan MT

I put the initial field in the form as when they created an entry in the
form, their initials would show.
My problem is that when i create report I want their full name to appear
rather than their initials, how would I do that?
Click to expand...


Change the report's record source to a query that joins the
two tables on the initials field.
 
ake,
If you're saying that NameInitials is one field with values
such as "Juan dela Cruz JdC", then you'll need to rethink
your table design.
Because names differ in their spaces, and your initials differ
in length, there's no way to logically extract the initials from the name.

Never store more than one value in a single field.

You should have 3 fields instead of just one...
FirstName LastName Initials
Kate WinsletKate KW

On your report, you can concatenate the FirstName and
LastName to display a "complete" name.
A calculated text control named FullName would have a
ControlSource of...
= FirstName & " " & LastName
and would display the name properly.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
What do you do when two people share the same initials?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top