Access 2007 Parameter Question
Posted on 2011-09-02
I have attached a copy of my database I created. The parameter query for Driver License Number is pulling duplicate records. When I enter the Driver License Number for example, "875442116" I am getting 12 records. I want only the three records for Vehicles, and 4 records for Weapons to show ad have the Point of Interst record show one time and the ciontct one time. There shouldbe only 7 records to show in lieu of 12.
Am I doing something wrong with the parameter query? I believe I have duplicate records being pulled.