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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

Part and Inventory Search

Back
Top