Thanks Galaxiom, that worked. Yes, my field names don't actually have spaces in them, i just made a small mistake there typing it in.
And yes, I realise that I have done it in a weird way, i will look into making it right.
Thanks Guys,
John
Hi,
I am setting up a database for a computer building company, and have nearly perfected my system. The one thing that I can't work out how to do is SUM several fields of records to get the total price for the computer.
Basically my table is like this:
Motherboard Price| CPU Price |...|Total...