label setup

[Rogeman]

Hi,

I have a database :-
female male Surname
Anne Adams
Bob Brown
Clare David Evans
...........>
I need to end up with labels as follows:-
Anne Adams
Bob Brown
Clare Evans
David Evans
..................................

Male and female are in different columns and couples with same surname are in the same row.
I am printing on sheets of 10 labels. Up to 500 names in total.

In my labels report I need to Print each name as an individual person.
ie.from above table, 4 individual labels.
In a Query I select male or female Forename data
but I have male surnames appearing in the female selection but with no male forename.
The opposite occurs if I select Male forenames.
It looks as though I am selecting all surnames but only print male or female.
How can I select all names with forenames and surnames for each individual?

Regards

Roger

 

[Rogeman]

Thanks Pat,
Your answer was a bit above my ability, I read it many times but decided plan "B" was next stop, ask the wife what she really wanted. It turned out that she needed the labels printed out for each days new entries, not all of them. This made it easier as I could now use ">=Date ()"in my Query and select either Male Report or female Report in each case.
This way I could print out each days entries of Female, then Male.
There may be a way of doing both together but this achieves my goal so I will stick with it.
It pays to make sure you are doing what the customer needs even if it is your wife.


Thanks again

Roger