G Guest Aug 14, 2007 #1 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.
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 Aug 14, 2007 #2 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]
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]
