How do I Query

M

Maniac

I have only one field for name in my data base. How do I append table
inputting the first two or three alphabets of name field.
 
J

John W. Vinson

I have only one field for name in my data base. How do I append table
inputting the first two or three alphabets of name field.
Click to expand...

Please explain what you mean here. "Append table"???

You certainly should NOT store the first two or three letters of the name
anywhere. You can create a Query based on the table with a calculated field

Initials: Left([namefield], 3)

to display the name; you can search for names using a Query with a criterion

LIKE [Enter start of name:] & "*"

to let the user type "joh" and find Johnson, Johannes, Johnston, etc.


John W. Vinson [MVP]
 
Top