First Post! On Creating Conditional Reports (No, Not Conditional Formatting)

[Counterpoint13]

Hi,



As said, this is my first post on this forum! Greetings everyone! : )

Okay, so here's the issue: I am looking for a way create a report that is conditionally filled with data.

For example imagine I have a table Customers and it has three columns: QuantityAdults, QuantityChild, and QuantityInfant.

I want to display in a report the quantity of each in a single line, like so:

Number of People: 1 Adult, 2 Child, and 1 Infant.

However, I do not want something like 0 Child or 0 Adult to appear, I only want to include the quantity if it is 1 or greater.

So for example if in my Customers table: QuantityAdults = 1, QuantityChild = 2, and QuantityInfant = 0 then my report would display on a single line:

Passengers: 1 Adult, 2 Child

I am new to Access, so please keep that in mind. One more thing: Please try to avoid using code unless it is the simplest solution, that is what I am looking for a simple that-makes-sense solution!

Thank you all!


Best wishes,

Counterpoint

[Bob Fitz]

Are the values in the fields numeric (eg: 1, 2, 0) or are they alpha-numeric (eg: 1 Adult, 2 Child, 0 Infant)

[Counterpoint13]

Hi!

I would much prefer them to be numeric as that would be easier to handle (for example preform math on, etcetera).

Thank you for the quick reply! : )

I am sure this is possible, I just have not been able to locate a good solution!


Thank you,

Counterpoint

[Bob Fitz]

As with many things, there is more than one way of doing things. The attached db illistrates three ways. They require the table data to be numeric.
Post back if you need any explanation.

[Counterpoint13]

Hello again!

The pictures below outline what I am looking for more specifically. I checked out Bob's attachment, but all three of them did not visually look like what I was looking for.

My goal is to combine table data to create a report that is formatted like this:

ID: 4
Number of People: 1 Adult, 2 Child

Instead of listing out the data under each respective column, I want to combine such data in the format as specified above.

Please view the pictures below, as they explain specifically what I am looking for.

Please do not hesitate to ask for clarification, I would be glad to provide such!

Thank you all! And thank you Bob in particular for your efforts! : )


Best regards,

Counterpoint

[Bob Fitz]

Perhaps the attached db is what you want?

[Counterpoint13]

Bob's solution did accomplish what I was trying to do, however I was able to find another solution without using purely code. An additional solution to creating is located at: http://www.utteraccess.com/forum/Cre...-t2003783.html

Thank you to all who helped! Sorry for the long wait time before posting again, but I do believe thanks are in order!


Cordially,

Counterpoint