2 fields in the same column

[kazza]

Sorry if this is in the wrong place. I've got 2 different fields that hold the same type of data. i want a report that has boththose fields in the same column.

IOW I've got a form that takes info about classroom bookings. I needed one for the am and one for the pm. So i have amSchool and pmSchool fields, and the same for number of kids coming to each. Now i want a report that shows all the schools and how many kids came for each, with no diffrence between am and pm.

Any suggestions would be great!!

[comment]

Make a separate record for each booking. Use one field for the number, one field to indicate am/pm.