Microsoft Access

[radar]

I need some help in Access.

I currently have a form that allows a user to select a number of products. When the product is selected a quantity box changes to the default value of 1, the cost of a single product is brought up in another box adjacent to that and the final box is a total box which is [quantity]*[Cost].

There's one more field that I want and I would like for it to be Sub Total. How can I get a text box (locked) to show the total of [Quantity]*[Cost]?

Currently I have tried Count([Quantity]*[Cost]) Sum( of that ) Sum of ([Total] and Count( of total) but they haven't worked. What can I do?

[Sp3culuM]

Wow, it's been so long since I used Access. If you'd have asked me 2 years ago when I did my Advanced Diploma I could've told you, right now I can't remember anything about it <img src=\'http://www.killanet.net/forum3/public/s ... /blink.gif\' class=\'bbc_emoticon\' alt=\':blink:\' />