Recent content by cb1

Thanks for the response ebs17, could you elaborate a little on this please, and how text files help preserve the 'data type security' for all records. Will suggest using a text file for the export destination and to use this for the import.

Are there any common issues/challenges when it comes to exporting a full table of data from an access database out to a currently blank Excel xlsx file? We need to be sure an export of a large table with multiple fields of different data types, exports completely and successfully to a blank...

If I read your question properly it is as simple as below to get the latest date in a date/time. select max([yourTable.dateField]) as LatestDate from yourTable

could you not use the max function?

I'm trying to define what I was hoping would be a fairly simple query in an access DB, but running into a few difficulties on the best way to achieve the result I am after. Basically I have 2x tables. In each table are 3x fields of interest, empName, code, accountnumber. What I need to do is...