Recent content by sglavanovi

I've managed to solve my problem by combining dlookup function with my select and update queries. Thx anyway!

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...

Thanks a lot! I succeeded to create the sets and use them, now need to create copy button to automatically add the sets to my samples and collect the results. I'll let you know if i succeed or fail :D Cheers! Sinisa

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...