Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
I want to query the ParksInventory field (which is yes/no) to only display the "yes" results. I've tried the "where" statement, but can't seem to get it to work. Anyone got a solution?Here is the current SQL:select [PropertyID], [Property], [Zip], [Address], [YearAcquired], [Status], [OwnedAcres], [UnownedAcres], [ParkType], [ParksInventory]From [dbo].[tblCamp]Thanks,Glenn
Glenn,try the following query:
select [PropertyID],