Iam currently working on an Access database but am finding it very hard to reduce the Total number of products in the stock table every time a single product is sold. This may be difficult to understand but consider a super market whereby every time a sale is made, the inventory levels reduce. pliz help
Does access have something like 'update table set col = col - amount where ...'?
he is write dear
update ur table time to time
by using
update tab set value=" " where produact="xyz";
u may use trigger
I recently rejoined the workforce after seven years of being a housewife. I now have a job where I do alot of data entry in Access, Word, Excel, QB, etc. I vaguely recall a feature in Data Entry where if you have a long string of text that you use often, you can program one of your Function Keys to rembember that text string. Does anyone know how to do this? Your help will be greatly apprecitated.