<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=668533413-25072003><FONT face=Arial color=#0000ff size=2>or
better still, if there is a tendency to use subqueries:</FONT></SPAN></DIV>
<DIV><SPAN class=668533413-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=668533413-25072003><FONT face=Arial color=#0000ff
size=2>PARAMETERS [Enter table name] Text ( 255 );<BR>SELECT MSysObjects.Name,
IIf(IsNull([Expression]),[Name1],[Name2] & "(" & [Expression] & ")")
AS SourceTable<BR>FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id =
MSysQueries.ObjectId<BR>WHERE (((IIf(IsNull([Expression]),[Name1],[Name2] &
"(" & [Expression] & ")")) Like "*" & [Enter table name] & "*")
AND ((MSysObjects.Type)=5) AND
((MSysQueries.Attribute)=5));<BR></FONT></SPAN></DIV>
<DIV><SPAN class=668533413-25072003><FONT face=Arial color=#0000ff
size=2>B</DIV></FONT></SPAN></BODY></HTML>