how to use expression to define a column from another text column?

[access-green]

I've got a table with a column that contains the value of every
record's Genus and Species. For example, "Sequoia sempervirens" could
be a value in this column.

I'd like to write a query selecting from this table that creates two
columns, one for the Genus and one for the Species. I think using an
expression would do this, but I can't figure out how. Essentially, I
only want to put all the text before the space in the first column, and
all the text after the space in the second column.

Any ideas for the appropriate syntax?

Thanks in advance!

 

[Brendan Reynolds]

See the thread 'Split a field in two new fields' elsewhere in this forum.