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!

Recent content by gixer

  1. gixer

    Renaming query values found using like statement

    Okay thanks, I'll try that.
  2. gixer

    Renaming query values found using like statement

    What would the code look like for this? I've never created a VBA function. Thanks
  3. gixer

    Renaming query values found using like statement

    Once it's initally setup, it won't change too often. I could write an update query, but I don't want to change the data in the table. I'd rather just use a select query to change the representation of the values I deem needing to be changed. Also, the query values need to be found using a...
  4. 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...
  5. gixer

    Value Substitution using a CASE statement

    Cool, Thanks cmmrfrds!
  6. gixer

    Value Substitution using a CASE statement

    Thanks cmmrfrds. I still can't get the iff fuction to work. It tells me the expression is too complex. How do you use the Switch function in a select statement. Sorry, I don't know much about access programming.
  7. gixer

    Value Substitution using a CASE statement

    Thanks for the help. What if I want to use more then 2 expressions. eg. idiscounttypeid=104193,'Yes' idiscounttypeid=102441,'No' idiscounttypeid=102442,'Half' idiscounttypeid=102443,'Full'
  8. 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...
  9. gixer

    Value substitution

    Got it. END as columnalias
  10. gixer

    Value substitution

    Thanks Sunil. One more question. How do you do a column alias with a case statement?
  11. 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...
  12. gixer

    Funky Select statement

    Hey thanks very much for the help!
  13. 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...
  14. 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...
  15. 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...
See more

Part and Inventory Search

Back
Top