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 Excell 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 Excell 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.

 

[jdraw]

I recommend you start by working through this tutorial. It will lead you through the steps to go from a business description to a well designed data base structure.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip