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!

  • Congratulations Westi 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. Jayzxtx

    Change color of data series points in xy scatter plot

    Skip I am trying to make the scatter plot graph dynamic. For example I have 5 sets of columns each set containing 12 colums to denote 12 months wihtin a year. Each column set has a toggle button. When I push a toggle button It will hide one of the 5 column sets from the source data and the xy...
  2. Jayzxtx

    Change color of data series points in xy scatter plot

    am trying to use a toggle button in excel to change the color of certain points on a xy scatter plot based on the xy values from a data sereies. I wrote a macro that changes a specific point on the gragh,but i am trying to understand how to change the color based on the xy values of the data...
  3. Jayzxtx

    Problem with inserting Query

    Jerry, Thanks for the Help I am still having problems on where to insert the TOP Value SQL exression. I am trying to get the top 3 in my query to show up in my subform6. I attempted to write another sql command titled strGetSQL. Everytime I try to run this there says there is a syntax error.Any...
  4. Jayzxtx

    Display three largest records

    Jerry, Thanks but I am still a little unclear as to where to insert the query. I have been trying to insert the top 3 query expression yesterday with little sucess. I keep on getting syntax errors. Below I am going to past where I believe is the correct place to put the qurery. Could you please...
  5. Jayzxtx

    Display three largest records in subform

    I am trying to enter in a zip code in a combo box to show which service agents are the closest to the customers based on mileage. The mileage is used to calculate the travel cost which was done in a previous query. How would I filter my results to just show the three cheapest milage costs? Below...
  6. Jayzxtx

    Display three largest records

    I am trying to enter in a zip code in a combo box to show which service agents are the closest to the customers based on mileage. The milage would then be used to calculate the travel cost. How would I filter my results to just show the three cheapest milage costs? Below is my code I have been...

Part and Inventory Search

Back
Top