Adding query fields together

[QuickStep]

My company has a microsoft access table with about 1200 IDs containing names, addresses etc.
Now I want to print this out in an excel sheet because I want to create address stickers, but I want every cell in the excell sheet to add information about the columns in the database together. I might be very unclear, let me demonstrate what I mean:
The Acess file might look like this:

id | name | address
1  | john  | Street 01
2  | sara  | Street 02

Now I want to have 2 excell cells which contain the information like this:
name_address
name_address

In my example, 2 cells with the following information:

john Street 01
sara Street 02

So I dont want 4 cells, I want to add the information together from 1 Id to 1 cell, but I also want to add linebreaks to it, It must eventually become an address sticker

How can this be done?

 

[jeremie_ingram]

If you are using Access and Excel, then I suppose you are using Word for the label generator.

You can work this in 3 ways.

1 Create a query in access that concatenates the 2 desired fields. Then use the form creator with the label type you have and create them straight from access.

2. Import the data into Excel using the import from database feature, and concatenate the fields at that point. Then you can generate the labels from there in Word.

3. You can connect Word directly to the Access db and import the fields and align them as you desire into the label fields.

Which of these would best suit your needs? If you want to edit/manipulate the data before generating the labels AND not affect your db, then number 2 is what you want. Number 1 and number 3 are not that different, but I still prefer using word to create my labels so I generally go with the third option.

Let me know which would work best for you and we can start down that path.

 

[QuickStep]

3. You can connect Word directly to the Access db and import the fields and align them as you desire into the label fields.

That would be a good option. The label generator needs to generate 3x7 sticker fields in my case (3width 7 height)

 

[QuickStep]

Already found the solution, access got a very nice build-in feature for this

Thanks anyway