Hi



I have 3 tables and i want to run a report to pull data from the 3 tables. The 3 tables are user details but the problem i have is the 'user id' on 2 of them would be like 'jbloggs' but on the 3rd it is something like 'database\jbloggs'


I was intending on using a query to pull this data and then was wishing to have one report which the user would type 'jbloggs' and it would pull the data from the 3 tables.

Is this possible???

Many thanks
Paul