Recent content by THL

Hi Ranman, Thank you for replying, I have two tables one called 'tblEquiptment' which has multiple columns but in this case the important ones are 'EquiptmentID' and 'Current Stock Level'. The next table is called 'tblDeleteStock' and comprises of 'Remove Quantity' and 'EquiptmentID'. In the...

If I'm honest I'm not 100% sure where you are coming from. I need an update query that will only update the stock levels on the date rather then it being taken out straight away when the form is completed?

HI, I am making a database for a company that hires out equipment. I have made a form that is for booking the job in, it also has a subtable where the equiptment is listed with quantities. The job is taken out on the date, however at the moment the equipment comes out as soon as I complete the...

Hi, I am new to access and I am trying to create my first database. I am trying to create my first query which is to do with stock levels, I have one table that is stock levels and one with stock to be removed. The information for the stock to removed comes from a form that then stores the...