X
Xeijin
URGENT
I have an assignment to hand in tomorrow, I need to know how to perform
numeric calculations in access, I dont know very much about databases
so consider this a beginner's query!
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.
E.g.
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 available 99.
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 Monday!!!
I know I'm asking alot but I'd be really really greatful if someone
could help me out!!!
Cheers,
//Xeijin
I have an assignment to hand in tomorrow, I need to know how to perform
numeric calculations in access, I dont know very much about databases
so consider this a beginner's query!
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.
E.g.
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 available 99.
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 Monday!!!
I know I'm asking alot but I'd be really really greatful if someone
could help me out!!!
Cheers,
//Xeijin