christopher007
Instructor
I have a simple select query that has no criteria, therefore shows all records, I want to use the left function to strip out the first letter of a field called “Full Name” which is the primary key of the table, however if I write Prefix: Left([Full Name],1) I get this error “The specified field ‘[Full Name]’ could not refer to more than one table listed in the FROM clause of you SQL statement."
This only happens with this “Full Name” field if I change the query to use a different field instead of “Full Name” this doesn’t happen.
Any Ideas ?
Thanks in Advance Chris.
This only happens with this “Full Name” field if I change the query to use a different field instead of “Full Name” this doesn’t happen.
Any Ideas ?
Thanks in Advance Chris.