Check for duplicates

[Gorio]

I have a total of 3 tables monitoring the use of vehicles and equipment assigned to them. Each vehicle is assigned equipment as it goes in service and the equipment is returned when it goes out of service. The "Vehicle" table shows the status of the trucks, while the "Equipment" table shows the status and current location of the equipment. Prior to assigning the equipment to the truck I would like to check and see if equipment of that type has already been assigned to that truck. How would I go about checking for this?
Currently the user chooses the equipment for a truck and clicks on a command button that runs a macro which logs the equipment to the truck and places it in use. I would prefer that it check for duplicates and refuse to do so if this would be the result. Thanks in advance for your assistance.

 

[chuckster]

Have you tried using the find duplicates query wizard?

Click the new button from the queries section and follow the prompts.

HTH

 

[Gorio]

I've tried the check for duplicates query, but it does not seem to do what I need. If I understand it correct it is checking ofr duplicates in a table. What I am trying to do is see if adding the equipment will create a duplicate. In essence I wish to check before assigning the equipment to a truck and placing the equipment in a "In Use" status.
When I used the duplicates query it gave me a list of the equipment. All I wish is for it to give a yes no answer. How would I go about that?