Hi!
I'm building a db in access for a school project, and was wondering how to
make the value for a field the same as the number of records with the same
value in another field.
e.g.
DvdTitle = Pulp fiction
StockLev = 1
DvdTitle = Finding Nemo
StockLev = 2
DvdTitle = Finding Nemo
StockLev = 2
etc.
also (you can tell how little I've used access now...) how to say a currency
value(the price of each dvd)*a numeric value (the stock level) in the field
StockCost. I presume it is just "=Price*StockLev" in default value field.
Thankyou very much (in advance)
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003