MS Access Query
MS Access Query
(OP)
It has been awhile since I had to work on MS Access queries.
My workplace has an access query that kicks out no data when it is run. An older version of the Access file which points to the same datasheet .csv gives out the correct information.
Does anyone have anyone advice on how I can compare the 2 queries to see the difference.
My workplace has an access query that kicks out no data when it is run. An older version of the Access file which points to the same datasheet .csv gives out the correct information.
Does anyone have anyone advice on how I can compare the 2 queries to see the difference.
RE: MS Access Query
Csv is a text file, access wizard creates custom rules to translate it to linked/imported table. I would check field names, field types, dates in both databases first, to know that both applications understand the data in the source file in the same way. If the tables in access are the same, make a copy of both queries, remove conditions and add them one by one in both copies, testing the output.
combo
RE: MS Access Query