I need help generating a exception report or query

[Guest]

I am trying to determine the best method to obtain a exception report. I have
two text files that contain fixed asset information. One file contains all of
the company's equipment at the beginning of the year. The other file contains
all of the company's equipment at the end of the year. I want to be able to
generate a report that would show all of the equipment that was in the
beginning of the year table, but is no longer in the end of the year table.
Each record contains a unique serial number that I think I could use to find
the exceptions. Does anyone know the best method to accomplish this?

Carmelita Clinton

 

[gls858]

I am trying to determine the best method to obtain a exception report. I have
two text files that contain fixed asset information. One file contains all of
the company's equipment at the beginning of the year. The other file contains
all of the company's equipment at the end of the year. I want to be able to
generate a report that would show all of the equipment that was in the
beginning of the year table, but is no longer in the end of the year table.
Each record contains a unique serial number that I think I could use to find
the exceptions. Does anyone know the best method to accomplish this?

Carmelita Clinton

Go to the query tab select new and then select unmatched query.
It should step you through creating a query to find what is in
one table but not the other.

gls858