query syntax error

M

MaRSMAN

SELECT [EventsID], [EventName] FROM Events WHERE (([Catagory]=(Event
Catagory[EvtCatID])));
The above is what I have in my query builder
Events is a fld Datatype autonumber
EventName is a fld Datatype text
FROM Events iis the Table
WHERE Cataory is a fld datatype Number
Event Catagory is a tbl
EvtDCatID is a fld Datatype autonumber
The fld the result is to go in is
ChurchService Datatype number
Properties combobox tbl query
rowsource is the above query builder
bound column 1 column count 2
column width 0",1"
Iget a syntax error with the where part that is in ()
What is the correction
 
J

Jerry Whittle

SELECT Events.[EventsID],
Events.[EventName]
FROM Events, [Event Category]
WHERE Events.[Catagory]= [Event Category].[EvtCatID] ;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top