Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

union query not running properly

Status
Not open for further replies.

aperture

Programmer
Jul 25, 2001
22
US
hello all-

i have written the following sql statement in the row source of a list box.

SELECT Null AS strUWorMgrName, Null AS strRACF FROM qryAgfcyVisitbyRACF UNION SELECT DISTINCTROW qryAgcyVisiitbyRACF.strUWorMgrName, qryAGYVISITbyRACF.strRACF FROM qryAgcyVisitbyRACF;

when i attempt to execute the statement and fill the list box, i get an error box reading "Syntax Error (Missing Operator) in query expression '()'."

can anyone catch the error?

thanks!

ap




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top