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

  1. SpeedStick

    Separating UTF-8 from Non UTF-8 Words

    I understand. However, I will try to make it work. I know other individuals might have needed some type of solution to this problem. I was just trying to seee if anyone else had already solved it. I have tried several solutions and none have worked.
  2. SpeedStick

    Separating UTF-8 from Non UTF-8 Words

    MajP Thanks for the direction. I will copy your code and troubleshoot to see if I can make it work. SpeedStick
  3. SpeedStick

    Separating UTF-8 from Non UTF-8 Words

    I need to identify characters/words that are UTF-8. I am just trying to either highlight a cell, a word or a letter that indicates it is UTF-8. I currently have the data stored in Microsoft Access and I will export it Microsoft Excel. The ultimate goal would be to try to separate UTF-8 words...
  4. SpeedStick

    Finding UTF-8 characters in Excel or Access

    I need to identify characters/words that are UTF-8. I am just trying to either highlight a cell, a word or a letter that indicates it is UTF-8. I currently have the data stored in Microsoft Access and I will export it Microsoft Excel. The ultimate goal would be to try to separate UTF-8 words...
  5. SpeedStick

    Access 2007 - Percentages in a Report

    Thank you for your post. It does work. Thank you for your help.
  6. SpeedStick

    Access 2007 - Percentages in a Report

    Thanks for the suggestion but it still has the information in that same scientific format. Is there a way to not displaying the information in that format? Right now the my inforamtion is being displayed as 1.27693385503062E-05 even with changing the format to percentage.
  7. SpeedStick

    Access 2007 - Percentages in a Report

    I am trying to display percentage results in a text box. However, the results are coming out in this form 1.27693385503062E-05. How do I get these results to be displayed as regular percentage results? The equation I am using to calculate my results is: sum([Total])/19578148).
  8. SpeedStick

    Forms and Division

    All I want to display is this single record "TotalPT" on this text box.
  9. SpeedStick

    Forms and Division

    Dear Duane, Thank you for your response. Yes, this table has single record. I tried to use DLookup with this format =DLookup("TotalPT" , "Total") However, I get an error message when using this formula. Scott
  10. SpeedStick

    Forms and Division

    I have form that I trying to complete. I have 1 text box that I used this function (=Sum([CountOfPT])) to total the number of records for a field. I need to take this field and divide by this: Table Name:Total Field Name: TotalPT. How do I format a DLookup to pull Total!TotalPT into the form...
  11. SpeedStick

    Query Help

    ...tblSubscriptionInformation.EndDate, tblSubscriptionInformation.Status FROM tblSubscriptionInformation WHERE ((Year([EndDate])*12+DatePart("m",[EndDate])<=Year(Date())*12+DatePart("m",Date())+1) AND ((tblSubscriptionInformation.Status)="Current")) ORDER BY tblSubscriptionInformation.EndDate...
  12. SpeedStick

    Query Help

    All, I need to write a query in SQL Server 2008 that will find all records that have an end date for next month and also all records for the previous months. This query needs to be re-used in subsequent months. Thank you, Scott
  13. SpeedStick

    Comparing 2 Columns

    How would set up the both functions? Would they be impedded in each other or would you set it up run one functiona after the other?
  14. SpeedStick

    Comparing 2 Columns

    Is anyone aware of VB code that can resolve this issue?
  15. SpeedStick

    Comparing 2 Columns

    Yes, exactly that is what I want. Thank you for the example. I posted my example just during the time you posted your example.
  16. SpeedStick

    Comparing 2 Columns

    Also, I would like to highlight the entire range for numbers that have different values. So below, 655 and 670 all there rows would be highlighted. Number Letter 655 G 655 K 655 G 655 K 655 G 659 T 670 K 670 K 670 G 671 A 671 A 671 A
  17. SpeedStick

    Comparing 2 Columns

    Dear Skip, Thank you for answering my question. One tweak, if I need to highlight the lease common letter - see below. In essence, if there are mulitple least common values and highlight each one of those for each instance they occur. Thank you for your help. Scott Number Letter 655 G...
  18. SpeedStick

    Comparing 2 Columns

    Dear Skip, Thank you for answering my question. One tweak, if I need to highlight the lease common letter - see below. In essence, if there are mulitple least common values and highlight each one of those for each instance they occur. Thank you for your help. Scott Number Letter 655 G...
  19. SpeedStick

    Comparing 2 Columns

    ...I used the CountIFS() in 2007 application. When I implement it highlighted the items in before the correct item. What suggestion would you have to correct this item. In addition, what were the 2 dashes (--) in the other equation suppose to be. =SUMPRODUCT(--($a$2:$a$999=A2)*($b$2:$b$999=b2))=1
  20. SpeedStick

    Comparing 2 Columns

    Thank you for your response. I used the CountIFS() in 2007 application. When I implement it highlighted the items in before the correct item. What suggestion would you have to correct this item.

Part and Inventory Search

Back
Top