how to seperate columns in msaccess

i have columns
like
trend setter 15
tredn setter 30
trend setter 40
trendsetter super 20

i need to seperate colmuns based on last space like
columna   columnb
trend setter     15
trend setter      30
tend setter        40
trendsetter super      20
romeiovasuAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dale FyeConnect With a Mentor Commented:
SELECT Left([yourField], instrrev([yourField], " ")-1) as ColumnA
, Mid([yourField], instrrev([yourField], " ") + 1) as ColumnB
FROM yourTable
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Not sure I understand the question... could you give a little more detail please.

Is this on a form or report?

 What is the resulting format you want?

Jim.
0
 
romeiovasuAuthor Commented:
i am trying to seperate the columns

example
trend setter 20
under columna
i want trend setter
columnb
i want 20
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.