Display text from combo box in report side by side

[webvine]

I have a form that has a combo box that allows me to select many choices. On my report I have the combo box on there to display the information of which I do see and that is what I want, but it displays the choices one underneath the other. How do I get the information to display side by side - as in sentence order?

 

[dhookom]

Combo boxes don't allow multiple selections. Can you provide us with an example of what you have for records and what you would like to see in your report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[webvine]

I guess I was trying to explain it as simple as possible. Sorry if it didn't make sense. Let me try to explain it this way. I have a form, that has subforms that I can select from a list and select one or more items. This information is saved in its own table that through relationships I know what info goes to what person. One of the choices is what states someone works in, which can be several states. When I make my report and I put this field on there it displays the information but instead of the information listing each state one underneath the other, I wanted it to display side by side.

Does this help with a clearer view of what I am trying to achieve?

 

[dhookom]

If you want to concatenate all the states into a single expression, there are at least two FAQs in the SQL Queries forum faq701-3499 and faq701-4233.

If this isn't what you are looking for, please come back with an example as I asked before.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[webvine]

Thank you for the suggested FAQ's, I took s quick peek at both and they look like what I am looking for. But it looks like a lot of code - would there be anything simplier?

My example would be as mentioned before, if a person works in many states then the info on the report looks like this:
CA
NY
WA

How I would like it to look on the reports is as follows:
CA, NY, WA

Any other suggestions would be very much appreciated.
Thanks so far for the help.

 

[dhookom]

This ain't much code. I am not aware of much simpler. You could use a multiple column subreport of states.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[webvine]

Ok - I will take a look at both FAQ's that you reccommended and see how I can implement it into my report. If I get stuck I'll reach out again for help.

Thanks for the help.

 

[webvine]

Well I have been trying to work with the 2 examples given in the 2 FAQ's and I am not getting how this works. Is there an easier way to break this down so that it can be understood? I'm not understanding the process or what goes where. Any help would be appreciated.
Thanks.

 

[dhookom]

There is an example of how to use the generic concatenate function at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

If you are still having issues, come back with your exact table and field names with sample records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[webvine]

PERFECT! That was exactly what I needed to see, a sample of how it is used. By following the example I was able to create the same thing and have it display on my report as I wanted it to. I also used the same technique on a couple of other fields so it will have information on the report display the info side by side instead of one underneath the other.

How do I give you a star for your getting my through this, because of you I succeeded, and you certainly deserve a star for this. (I had looked through all the help files in my Access database and on line at microsoft and was not finding what I needed.)

Thanks so much for following through with me!!!!