Total between 2 fields

[jenncivello]

I have a license table that has 2 columns, # of Licenses and # of Licenses Used. I would like a 3rd column that gives the difference between the 2 fields. Is there a way to do this?

[orange]

You should NOT use special characters (# and space) in your field and object names.
What is the purpose of License Table?

Do you know what a Select query is?
see http://www.techonthenet.com/sql/select.php

[jenncivello]

ok, i will fix this, thanks.
Its to keep track of the numbers of licenses we have

[orange]

I think you should research
database table design and
normalization