Hi Sunjar and welcome to the forum.
To total up all the Ms and Fs for that particular record try these calculations, Assuming your gender fields are numbered 1 through 5:
CountMale ( Calculated Number )
If ( Gender1 = "M" ; 1 ) +
If ( Gender2 = "M" ; 1 ) +
If ( Gender3 = "M" ; 1 ) +
If ( Gender4 = "M" ; 1 )
CountFemale ( Calculated Number )
If ( Gender1 = "F" ; 1 ) +
If ( Gender2 = "F" ; 1 ) +
If ( Gender3 = "F" ; 1 ) +
If ( Gender4 = "F" ; 1 )
I hope this helps
works great, Thanks!
I have a table that has the names of up to four different people (each person entered in a separate field).
This is not a good arrangement. You should have a separate related table for the people, with individual records for each. A lot of things will become easier that way.
Yes. This is something I argued hard with my client about. I am importing records from an Acrobat PDF form (csv file). And despite my best arguments, this was the way the form needed to be set up (that is, with up to four people on each). Apparently people are happier to book a group with their friends if they are on the same form.
If you know an easy way of separating the extra people from an imported csv file that would certainly make things easier.
(I realise that importing the file several times, importing the person 2, 3 and 4 into the separate table would work, but that is long and cumbersome.)
If you have any suggestions I would certainly appreciate them.
- You can use a portal to show your (up to 4 people) records on one page.
- You could import your CSV into a temporary table and use a script to extract this infor and put the information into the desired fields of your table.
The looping script you could create for this might not be all that complex.