M MartinO Registered User. Local time Today, 04:21 Joined Oct 8, 2002 Messages 22 Oct 29, 2003 #1 I'm trying to strip out an initial in a query from a Forename field. I'm using 'Left([Forename],1)' but all I'm getting is '#Error'. Am I missing something or does Access 97 not actually respond to this function?
I'm trying to strip out an initial in a query from a Forename field. I'm using 'Left([Forename],1)' but all I'm getting is '#Error'. Am I missing something or does Access 97 not actually respond to this function?
Mile-O Back once again... Local time Today, 04:21 Joined Dec 10, 2002 Messages 11,316 Oct 29, 2003 #2 Does the [Forename] field have a value?
M MartinO Registered User. Local time Today, 04:21 Joined Oct 8, 2002 Messages 22 Oct 29, 2003 #3 Its populated with 'Fred' 'Bill' etc. etc. and the field in the table that the query is based on, is a text field.
Its populated with 'Fred' 'Bill' etc. etc. and the field in the table that the query is based on, is a text field.
