Welcome to the TechSpot OpenBoards. Please read the FAQ if you have any questions. Login to participate.

Go Back   TechSpot OpenBoards > OS & Software > Misc. Software & Utilities

MS Access - need help, a piece of advice

Reply
Bookmark / Share this page
Thread Tools
  #1  
Old 07-06-2005
Newcomer, in training
 
Member since: May 2005, 3 posts
MS Access - need help, a piece of advice

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
Reply With Quote
  #2  
Old 07-06-2005
TechSpot Evangelist
 
Location: has left the building
Member since: Aug 2003, 8,160 posts
SQL is the answer.
Select your cells from the table where checkbox = "Y"

See samples here:
http://www.1keydata.com/sql/sqlwhere.html
Reply With Quote
You can remove this banner by registering, join the TS Community for free.
  #3  
Old 07-06-2005
Newcomer, in training
 
Member since: May 2005, 3 posts
Thank you !

Thank you very much ! That easy - but working :-)
Have a great day !

Greets

Artie
Reply With Quote
Reply
Thread Tools

Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Access Denied, when i access the my computer icon and its properties redkintanar Windows OS 2 12-07-2007 08:21 AM
The art of gaining local access Phantasm66 Misc. Software & Utilities 9 01-18-2006 01:40 PM
Can someone help, I can't access shared files on my home network PJonse Storage & Networking 9 03-25-2005 09:07 PM
Access Experts needed raebabe Misc. Software & Utilities 1 12-17-2004 03:32 AM
Help - can't access XpPro PC over network technoheckno Storage & Networking 24 11-24-2004 06:28 PM


All times are GMT -4. The time now is 01:46 PM.