Hello. I have a database in access that stores the features of a car. If it has power windows - the value is 'True' and if it doesn't have cruise control - the value is 'False'.

What I am trying to do is develop a recordset that will only return the 'True' values so when the details of this car come up, it will display only the features that were entered with a 'True' value.

I am using Access 2000 database and Dreamweaver MX with .asp.

Thank you in advance for your help

Select *
From yourDatabase
Where yourField = 'true'

thank you for your response...

The problem with that format is that I want it to tell me what values are true.

For example - I upload a 1990 Lincoln Town car. It has Power steering, Power Windows, AirConditioning etc...

What i want to be able to do is show all the 'True' fields for that particular inventory number.

If it doesn't have Cruise Control - I don't want that field to be displayed.

Hope that makes some sense...

Thanks again

your gonna have to build a conditional statement to display your records

using "show if...true"

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com