query to combine two fields

  • vickriz
  • Novice
  • Novice
  • User avatar
  • Posts: 31
  • Loc: Phlippines

Post 3+ Months Ago

hi to all, and good day..
i dont know where to post my subject, so iL give a try here.
im using Access 2000 and i want to make a query [in SQL statement]
for the (2) fields and combine them with comma delimeted.
lets say:
fieldOccupation1 fieldOccupation2 fieldOccupation
Farmers Businessman

the result after the query should be:
fieldOccupation
Farmers, Businessman

please need help badly...

thanks in advance
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 71 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.