Member Avatar for kdee

Hi!

A bit of a stuck-up.

I have a problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing).

I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line.

in a query is following:

Field1

Value1

Value2

Value3

Value4

I want those values to be shown on a report like:

Value1,Value2,Value3,Value4 etc... :rolleyes:

If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself.

Thanks in advance

  • 4 Contributors
  • 4 Replies
  • 156 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by Uncle Gizmo
Member Avatar for Uncle Gizmo

Please find attached solution I developed for a similar problem with a customer's database last year. It should give you some idea about how to solve the problem

cheers Tony

FieldDataHorizontalyOnReport.zip (21.98 KB)
Member Avatar for Incubus1062

Dude, that was great. I've been trying to figure that out for some time now. Thanks a ton. You've opened me up writing expressions in queries. I didn't think I could do it in Access.

Please find attached solution I developed for a similar problem with a customer's database last year. It should give you some idea about how to solve the problem

cheers Tony

Member Avatar for lynnie473

Please find attached solution I developed for a similar problem with a customer's database last year. It should give you some idea about how to solve the problem

cheers Tony

Hi - I have the same issue, but I get stuck in a 'please log in' loop on the site when I try to download your zip file. Any chance you could email it to me?

Member Avatar for Uncle Gizmo

I've only just receive notification of this thread, I see it was posted six days ago, did you manage to download the file or do you still want it? If you do,,, what your e-mail address. Cheers Tony

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.