Search results

I have a table with duplicate records but also semi duplicate records. SpNo SpDate DateAuth Result CulComment B1445677 15/06/2020 26/06/2020 NO res myo comm B1445677 15/06/2020 26/06/2020 -------- myo comm...

I need to compare a small source table (upto 100 records) with a much larger destination table (20000). If the ID is the same I need to delete any records (there may be more than one) that are older in the destination table. It doesn't matter if the other fields differ as the newer records...

I have 31 tables which as they are updated are appended to the Master table (bad name should call holding but for this example I called it Master). The Master Table could have upwards of 5000 records depending on when it is updated. I need to remove the duplicates before moving the data to...

I have an excel spreadsheet (example attached) which is populated by lab equipment. The key field is the specimen number and specimen type. Currently for every antibiotic there is a row with its result. My output is 3 complete worksheets so a lot of data. I need to create a database with one row...

This is probably dead simple, I have always been used to writing vba for Access Xp (haven't done so for a few years) etc where Dim db as database Dim rs as recordset Set db = Currentdb Set rs = db.CreateTableDef (sorry your correct) etc etc but I cannot seem to do this anymore in...

I have records which get printed each month for staff to be paid. What I would like to do it when a record has been sent to print a check box be filled in the main table so I can determine whether a record has been printed off already. This is incase staff are late with their paperwork I can...