Search results

That did it I had to get rid of the join on the table and add <=20 and all works great thank you .

There is about 5 fields first name last name dob and a document number the document number is about 7 digets long. what I want to do is I have a table with a list of 3000 records and when i import a list into the 2nd table i want to run a query that will give me all of the same records from 1 to...

I have a small db only 2 tables table1 table2 what im looking at is if table2 has a record that is the same as table1 it would show after i run the query. One or the fields is a number and i want whatever table2 number is it will look for that number and + and - 20.