select query anyone?

[jenawyn]

Hi,
I have a problem with a query.
I have
Mydate RepID SCategory Number HCategory Number
what i need to do is create a new field on the query line
Total:
Scategory number sum
subtract
Hcategory hand number sum + hcategory recieve sum
Equals The value

Any Ideas
I guess it will be a select but I really have no idea how to set it up

thanks for any help

 

[Memnoch1207]

Mydate RepID SCategory Number HCategory Number
what i need to do is create a new field on the query line
Total:
Scategory number sum
subtract
Hcategory hand number sum + hcategory recieve sum


Where does the Hcategory hand number sum come from???