query syntax error

  • Thread starter Thread starter MaRSMAN
  • Start date Start date
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
 
SELECT Events.[EventsID],
Events.[EventName]
FROM Events, [Event Category]
WHERE Events.[Catagory]= [Event Category].[EvtCatID] ;
 
Back
Top