HELP!!!!!!!!

[Guest]

i need a breakdown into gender, but the prombles is that i have one field
that has got the following infromtion in that is Title Firstname surname,

how can i do a queries that only gets the first part of the field upto the
spaces

 

[Guest]

Try

Left([FieldName],Instr([FieldName]," ")-1)

 

[Ken Snell \(MVP\)]

FirstPartOfInfo = Left([FieldName], InStr([FieldName], " ") - 1)

 

[Rick B]

Please note that you should not store three pieces of data in one field.

What about



Mr. Billy Ray Cyrus

Mrs. Karen Le Compte

etc.

 

[Brendan Reynolds]

As others have suggested, you can use the Left$() and InStr$() functions to
grab everything to the left of the first space. Be careful about relying on
this as an indication of gender, though. There are plenty of titles that are
not gender-specific - "Dr.", for example.