Recent content by SpeedStick

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.

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

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...

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...

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

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.

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).

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

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

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...

All: Thanks for the suggested. I developed my own solution for myself. Below is solution: SELECT tblSubscriptionInformation.CompanyName, tblSubscriptionInformation.EndDate, tblSubscriptionInformation.Status FROM tblSubscriptionInformation WHERE...

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

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?

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

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