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

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 49 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.