Recent content by CJSpinner

  1. C

    Update Query using SWITCH function

    Okay, I'm a total newbie. So what's the recommendation to storing a calculated value? I will say that I'm refreshing my data from an external source on each call.
  2. C

    Update Query using SWITCH function

    Gasman, I didn't quite understand what you were saying was backward, but it did lead me to the solution. Thank you.
  3. C

    Update Query using SWITCH function

    Disclaimer: I must be the dumbest person trying to use Access. I am trying to update a column [Stratification] with different text values depending on what is found in another column on the same record/table. Table is called [YearsOfQuotes] Desired result is to look at the GM% (Quote) column...
See more
Back
Top Bottom