Search results

Hi, everyone! I have 2 tables in my access database and I'm trying to update a field in one table with the minimum value (date) of the field in another table. I have created query to find minimum value in table 1 but I'm not sure how to update value in table 2. Tables are linked via ID filed...

Hello! I have created access database for laboratory sample evidence and now I would like to use it to collect analysis results. The information about sample is stored in one table (sampleid, samplename, date, ....) One of the possibilities is to create another table, only for the results...