Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by woogoob

  1. woogoob

    Simple Select Statement to return data containing Single Quote

    I figured it out...double up single quotes
  2. woogoob

    Simple Select Statement to return data containing Single Quote

    I have a table with some data that contains single quotes. eg... Table: tbl_Tools Column ITEM Data... Garden Hose 50' PVC Pipe 25" Can someone tell me the SQL statement to return records that contain single quotes. I want to use 'IN' in the WHERE clause because I have a list of items i...
  3. woogoob

    Problem with List Query (IN Keyword) using Parameter

    I meant to say Select * from tblTest where ITEM_NUMBER in ('abc', 'xyz') This query works
  4. woogoob

    Problem with List Query (IN Keyword) using Parameter

    This query works Select * from tblTest where in ('abc', 'xyz') But for the following query: PARAMETERS parTest Text ( 255 ); SELECT * FROM tblTest WHERE (((TBL_CustomerPricing.ITEM_NUMBER) In ([parTest]))); when I enter 'abc','xyz' in the parameter field, i get no records back. Please tell...
  5. woogoob

    How can I view tables, only switchboard is displayed

    Thanks for your help Maquis!!!
  6. woogoob

    How can I view tables, only switchboard is displayed

    I received an Access 2000 .mdb file. When i try to open it, a switchboard form is displayed. The menu at the top has disappeared and I have no idea how to get to the design area of this database. If I close the switchboard, I'm left with a blank window. Can someone tell me how to bring up...
See more

Part and Inventory Search

Back
Top