Search results

In my make loan form I am showing the charge due for that particular loan and the charge forany previous, unpaid loans (ie-debt) made by a member. I want to add the debt to the current loan fee and have that toal replace the value that was previously in my debt field. so say if member 3 has...

How do you use the value written in a control of a form as input for a query? eg-if the user inputs 100 into an itemid text box on a form, i want to use 100 as input for a query. I thought it was: Forms![name of form]![name of control on form] but Access automatically puts brackets around...

Wasn't quite sure where to post this. i've got 2 types of members in my system-member A and member B for the sake of simplicity, there is also 4 types of items that these members can get, lets call them item 1-->4, each item has a different price depending on the item iteself and what member...

I'm trying to work out the difference between 2 dates stored in a table. I want to work out how many days exist between [date1] and [date2] and update the value in another field of the same table. I can do this using a query but that way (correct me if im wrong) I can't simply show the value in...

I'm setting up a database to keep track of book/video loans. Trouble is that some items have more than 1 copy and it'd be a waste of time and space to enter the data for each item 2-5 times. I was thinking of having a drop down menu labelled "copies" for each item, so the user selects how many...