Read with Formatting | Join TechSpot! (it's free)



MS Access - need help, a piece of advice

Artie
07-06-2005, 09:34 AM
I have a pretty big database and now I need to create a report that will pull out ONLY items, cells selected in the table.
I have already created a check box column in the table but can't have the report pulling out ONLY what is checked.

Thank you for all the help


Artie

RealBlackStuff
07-06-2005, 12:25 PM
SQL is the answer.
Select your cells from the table where checkbox = "Y"

See samples here:
http://www.1keydata.com/sql/sqlwhere.html

Ad
07-06-2005, 12:25 PM

Artie
07-06-2005, 01:22 PM
Thank you very much ! That easy - but working :-)
Have a great day !

Greets

Artie

 Tech News

 Downloads
Copyright © 1998-2008 TechSpot.com. TechSpot is a registered trademark. All Rights Reserved.