Search results

I' m trying to compare a value in the import table against a value in a other table to check if this dealer is already is imported. AantalRec = aantal("Tmp_Import") MsgBox (AantalRec) For i = 1 To AantalRec SQLQ1 = "SELECT Tmp_Import.[Dealernummer Vestiging]FROM TblDealer INNER JOIN...

I'am working on a existing Database in Access 97 and me was asked to build a Import function fore this database. The importing function is not the problem and this is already working. No i'am strugeling to get the validation of this data. Whe have a Excisting form where whe manual enter the...

I got a dataset and I am genarating a report. I need the sum of a qry <3 years and 4 years 5 years and older than >12 years But it is kind of dificult to put this in 1 qry. Is it posible to make that kind of Qry in Access ?? Data is like Years v1 v2 .... 0 32 45 1 12 42...

Ok I already wrote a macro to import xls files from a local ore remote dir. but no I want to keep record of files that where imported to the Database. And I dont want to upload files that already are in the DB. Becouse this is going to be a automated process on a daily basis. I alsow need a...