Help!!!!

[netuse@debouck.]

NEED HELP I HAVE A TABLE(GATELOG) WITH GUESTS THA CHECK IN WHICH INCLUDES THE FIELD [PLATE] WHICH IS WHAT I WANT TO SEARCH I ALSO HAVE A TABLE WITH RESIDENT(RESIDENTS) VEHICLES WITH THE SAME [PLATE] FIELD THAT NEEDS TO BE SEARCHED AT THE SAME TIME

I HAVE A SEARCH FORM THT A USER PUTS IN THE PLATE AND HITS ENTER

THE SEARCH FORM IS BASED ON A UNION QUERY BASED ON SEPERATE QUERIES OF THE ABOVE INSTINCES
THE GATELOG QUERy ALSO ONLY SHOWS THE LAST DATE THAT PLATE WAS ENTERED
THE RESULT THEN OPENS A FORM WHICH DISPLAYS THE INFO

THE PROBLEM IS IT IS TAKING TO LONG TO DO ALL THE QUERIES

MY ? IS THIS I NEED TO SEARCH 2 TABLESBRING UP THE LAST ENTRY FOR SPECIFIED PLATE IN THE GATELOG

ANY HELP WOULD GREATLY BE APPRECIATED

BROCK