• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

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
0
romeiovasu
Asked:
romeiovasu
1 Solution
 
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
 
Dale FyeCommented:
SELECT Left([yourField], instrrev([yourField], " ")-1) as ColumnA
, Mid([yourField], instrrev([yourField], " ") + 1) as ColumnB
FROM yourTable
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now