[AccessD] searching into a union query...

Hi Kostas,

Off the top of my head, there is a wizard in Access to write a 'Look for
Duplicates' query.  You should be able to run it against this Union query.

HTH,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
Konstantinidis
Sent: Sunday, April 01, 2007 12:56 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] searching into a union query...

hey group,
I use the follown union

SELECT [Title], [Year], [IDdirector], [IDcomposer]
FROM [MT_basic_char]

UNION ALL SELECT [title_collection], [year_collection], 
[IDdirector_collection], [IDcomposer_collection]
FROM [RT_AM_COLLECTION_SUBFORM];

because of about 15000 records what I need to know is if there is a [Title] 
either in MT_basic_char or in RT_AM_COLLECTION
I was wondering if it could be possible to make a button, when clicking to 
get back a searching form on that Union Query
something like the default msaccess's

    Screen.PreviousControl.SetFocus
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

but on that specific Union Query

many thank's
/kostas 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com