Show how many times an item is sold?

[xtrareal22]

Hello,I am a beginner.
I have a transaction form with the fields(TranID,ItemID,Quantity,Date of sale,Price] i added unbound control(textbox) to the form which i want to show me how much of the same item was sold.
Example I sell coke today so the transaction of coke was once so when i sell coke again i want it to show me that this item has been sold twice.How do I do that?Is it even possible?

[pbaldy]

You can try a DCount() with a criteria:

http://access.mvps.org/access/general/gen0018.htm

[xtrareal22]

Okay, so i did this for the conrol source
=DCount("[Stock ID]","Sales Table","[Stock ID]=" & [Forms]![Sales Form]![Stock ID])
but the problem now is that when i select the ItemId from the combobox and i have inputted data into the other fields,the textbox value is 0 and when i add the same item ID the field is displayed as 1.What do i do so that when i immediately select the itemID the field displays 1 and not 0.

[xtrareal22]

Never mind it was works good.thank you

[pbaldy]

Glad you got it sorted out.