Search results

I am using the following query to identify rows in one table that have no match in another: SELECT MAS.MASID FROM MAS LEFT JOIN IVT ON MAS.Field1=IVT.Field1 WHERE ((IVT.IVTID) Is Null); MAS is one file with MASID as the key. IVT is the other file with IVTID as the key This provides me a list...

I work for a company that has a mainframe application that produces "outgoing" files. They are downloaded to a server and converted to ASCII (all at one time) and then ftp'ed to various clients. We are converting to a client server application and I am in charge of verifying that the mainframe...

You probably should cut and paste this into Word so the columns below align I have a problem with a report. I have set up a generic process to compare any two files. After loading the files into an access database I run a series of generic queries and they identify any difference in any pair...

I am trying to set up a file compare process. I load the two files into two "matching" tables (there is a key field). I have a series of queries which find any differences in the various fields and displays them. My problem is that one field (Field4 - a tran code) is coded 1,2,3 in one file...