How to group people's titles by gender?

[Idznak]

I have a database with two tables. One for customers, one for the books that they buy.
I have a field for people's titles (Mr, Mrs, Miss, Ms) and I'd like to make a graph in Excel to show the relationship between gender and amount spent on books.



I'd like to just have two fields, male and female to put into Excel so the graph makes more sense than all four titles and then an explanation that Mrs, Miss and Ms must be added together to compare the total spent with the males.

How can I do this?

Thanks,
Idznak.

[RuralGuy]

How about creating a calculated field in a query that uses an IIF() statement for Male/Female?
...NOT TESTED...
IIF([Title] = "Mr" , "Male", "Female")

[Idznak]

How about creating a calculated field in a query that uses an IIF() statement for Male/Female?
...NOT TESTED...
IIF([Title] = "Mr" , "Male", "Female")

Thanks a lot, RuralGuy, this worked perfectly

[RuralGuy]

Great! Glad we could help.