Prev: date confusion
Next: cursor changes to hand when focus on label
From: MaRSMAN on 2 Feb 2010 16:31
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
From: Jerry Whittle on 2 Feb 2010 17:18
SELECT Events.[EventsID],
Events.[EventName]
FROM Events, [Event Category]
WHERE Events.[Catagory]= [Event Category].[EvtCatID] ;

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"MaRSMAN" wrote:

> 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
 | 
Pages: 1
Prev: date confusion
Next: cursor changes to hand when focus on label