P Pete666 Registered User. Local time Today, 06:46 Joined Aug 29, 2006 Messages 28 Feb 15, 2007 #1 Can anyone help me in creating a field from a query which will pull the first word only from a specific field. Thanks.
Can anyone help me in creating a field from a query which will pull the first word only from a specific field. Thanks.
P PeterF Registered User. Local time Today, 07:46 Joined Jun 6, 2006 Messages 295 Feb 15, 2007 #2 Expr:Left([Yourfieldname];InStr([Yourfieldname];" ")-1)
P Pete666 Registered User. Local time Today, 06:46 Joined Aug 29, 2006 Messages 28 Feb 15, 2007 #3 Thanks for that... apart from it needing to be comma's instead of semi colons it works fine.
