Display Results if Field Filled In

Getting your data onto paper - or the web - Discussing the reports features of Base

Display Results if Field Filled In

Postby JAGS » Mon Dec 09, 2013 8:29 am

I am creating a database for a non-profit and what I am running into is each family could have as many as 12 kids in the family.

What I have done is created fields in my form for "child1name" "child2Name" "child3name" etc up to 12

Now what I want to do is have a label called Children and then have it list the names of the kids like Bob, Ted, Sally, etc.

How do I do this so it will search all 12 fields and then report only those that have names in them. One family may have 2 kids where one family may have 7.

I am new to all this so Thank You,

Open Office 4.0 on Windows 7 - 64 Bit
Posts: 10
Joined: Sun Dec 08, 2013 8:37 pm

Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests