Erm Hi everyone I'm new.
Sorry about the rather striking title, but I have an assignment with the deadline tomorrow and I need to find out how to
perform numeric calculations in access with different fields (i.e. adding numbers, minusing etc.)
Well, I had to make a project at school for my GNVQ ICT, I chose the advanced sales database, since its a project we have to
add in our own features and find out about them ourselves. Well I thought I'd create one for my company inside school, I
wanted to create a database that would print invoices and monitor all the resources we have. The project has to be in on
However all was going well until I came upon a slight problem, I'm not sure how to do calculations in Microsoft Access!
Well basically this is what I'm aiming at, its nothing too complicated really.
I have a table called RESOURCES which keeps track of all of the stock the company has (e.g. how much paper, how many mugs,
tshirts etc.). I want the database to be able to automatically take 1 away from the selected resource when a form is used to
file a new order.
I have a form asking me the details of the design, In the resources table I have set the quantity of mugs as 100, i.e. I have
100 mugs in stock and available.
I use the form and tell the database that I am making a design which will use 1 mug.
The database then goes to the resource table and takes 1 away from the available stock of mugs making the total mugs
I then the database to be able to do this automatically, when a checkbox is ticked, when the form is submitted I want it to
see which text boxes are ticked and take the correct consequent resources from the RESOURCE table.
I have Access 2003, I have attached the file incase anyone needs it, note that the Forms have NOT been made only the
resource, customers and orders tables have been created.
If someone could tell me how to do this I'd be extremely greatful, this is very URGENT I have to hand in the project on
I know I'm asking alot but I'd be really really greatful if someone could help me out!!!