Recent content by Reece92

ahh I see! sorry :) table 1: sieve weights: 315 tare: entered by the user once a month (number): the weight of the 315 micrometre sieve 250 tare: entered by the user once a month (number): the weight of the 250 micrometre sieve 200 tare: entered by the user once a month (number): the...

Thanks for the response :) I need all of my data in 1 table as the database has a lot of calculated fields ( I know that this is a sin in the database world). The sieve tare weights change over time, but the old data is valid for that record so I would like it to keep the old value! What do...

Update query to add data to table NOT overwrite! Hi guys! Im having an issue with an update query and looking for some help, I am pretty new to access so please bare that in mind :) The problem: I have a table that is updated from an update query which gets its data from a table, which gets...