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