Stuart McLachlan
stuart at lexacorp.com.pg
Wed Dec 8 20:23:05 CST 2010
If [Name] doesn't contain a space, the function will return an error. -- Stuart On 8 Dec 2010 at 16:49, Charlotte Foust wrote: > Offhand, I'd say the minus one is trying to return a negative value on > a field with nothing in it. > > Charlotte Foust > > On Wed, Dec 8, 2010 at 1:01 PM, Susan Harkins <ssharkins at gmail.com> > wrote: > Nevermind. <groan> > > Susan H. > > > Does anyone know what > #Func! means? I can't find a reference to it anywhere. > > In Access > 2010, I'm using a simple parsing expression: > > FirstName: > Left([Name],InStr([name]," ")-1) > > and this value shows up just > below the field header in Datasheet view. If I remove the -1 > component, #Func! disappears. > > Anybody know what this is? > > Susan > H. > -- > AccessD mailing list > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > Website: > http://www.databaseadvisors.com > -- AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd Website: > http://www.databaseadvisors.com >