I have a database set up which holds the names of guests coming on holiday.
I have a separate field in which I want to have the total number of occupants coming on holiday; i.e. if the occupants are Sarah, Andrew and Joyce, I want access to automatically work out that there are three people and put a "3" in the "occupancy field. I've attached a screen print to show what I mean.
I've tried to write an argument using the iif function but it didn't work; can anyone help please ?