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 Chriss Miller 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: *

  • Users: gixer
  • Content: Threads
  • Order by date
  1. gixer

    Renaming query values found using like statement

    Hi, I'm looking to to rename values returned in my MS Access query. Example table data: Companyname Juice Inc Juice Incorporated Juice Corporation Juice Corp Heat Ltd Focus Corporation I thought I could use the Switch function: Switch([Raw Data]![Companyname] Like "*Juice*","Juice...
  2. gixer

    Value Substitution using a CASE statement

    Help! I'm trying to run the following query in MS Access SQL, which I wrote in MS SQL Sever Transact Query Analyzer. select CASE qd.idiscounttypeid when 104193 then 'Yes' when 102441 then 'No' END as 'Selected', qd.tirecordstatus from quotedetail qd It works fine in Query Analyzer, but...
  3. gixer

    Value substitution

    Hi, I'm trying to do a simple query with a value substitution. In the table the value 'yes' is stored as an integer of 1 and the value 'no' is stored as an integer of 2. select responded from test If you run the query above here are the results: responded --------- 1 2 1 1 How would I...
  4. gixer

    Funky Select statement

    Hi everyone, I need help with a select statement. records in the details section should have either the iactionid value 117 and 129, or 117 and 37. A sample looks like this: icampaignid iactionid 10 117 10 129 11 117 11 37 12...
  5. gixer

    setting multiple values equal to one value based on PK

    Given the table below: iprofileid iownerid(pk) isurveyid 10 9 10 12 9 35 55 1 10 56 1 35 how would one write an update statement so that the iprofileid's are the same for the...
  6. gixer

    partial update

    I am trying to update part of an vchaddress1 field. An example is the following: 125 17 av NW I want to correct the "av" to "Ave" and keep all the rest. So it should look like: 125 17 Ave NW Is there anyway I can do this without manually going in and changing each...

Part and Inventory Search

Back
Top