display features if true value

  • Thread starter Thread starter Jimbo
  • Start date Start date
J

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.
 
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.
 
Back
Top