How to eliminate the text after and before the dash

[Jerseynjphillypa]

How would I write the query in the Criteria field to eliminate the text before the dash and then after the dash?



Since I am getting data like
US - Apple
FRANCE - Dell


So for the field Location, I only want to see US or FRANCE

And in the field Item, I only want to see Apple or Dell

[RayMilhon]

In one column you would use Left([fieldname],Instr(1,[fieldname],"-")-1) In another column use Right([fieldname],Len([fieldname])-instr(1,[fieldname],"-"))

although you may want to lookup the parameter order for Instr I think it's (starting position,string to look in, string to look for) but I could be wrong. I don't use it enough to be 100% sure.