display features if true value

[Jimbo]

Hello everyone. I have an access database for a auto dealership. One of
the tables is called 'Features'

Air Condition - Yes/No value option
Power Steering - "
Power Windows - "
Cruise Control - "

What I want to do is run a query that will only pull out the fields that
have a "True" value. So when I display the specific car, it will list the
features that this car has by running the query.

 

[Jeff Boyce]

(see your other post for a response)

 

[[MVP] S.Clark]

No! I prefer the method of creating a seperate table to hold each of the
features that the vehicle has.

tblVehicles
VehicleID
VIN
Year
Make
Model
etc...

tblVehicle_Feature
VehicleID
FeatureID

tlkpFeature
FeatureID
FeatureName
etc.

Because, when a new feature is introduced from the manufacturer (i.e.
OnStar), you don't have to make another field in the table and change every
query, form, and report that you already made.