DRW Query help

[Guest]

I have 8 different tables that each have a field called uEmail. What I want
to query is what tables of the 8 do not have a matching email address in the
uEmail field. Can this be done either with a query statement or Access query?

Dan

 

[Bob Lehmann]

Why do you have 8 tables storing the same information?

Bob Lehmann

 

[Stefan B Rusynko]

Not using the DBRW
- only w/ hand coded VBscript

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have 8 different tables that each have a field called uEmail. What I want
| to query is what tables of the 8 do not have a matching email address in the
| uEmail field. Can this be done either with a query statement or Access query?
|
| Dan

 

[Guest]

uEmail is the unique identifier for each record in each table. Each table
holds different information about the same person identified by their email
address.