Search results for query: *

...Operations <CLCS.LoanOperations@email.com>", email) message.Subject = subject Dim text As String = "<FONT size='3' color='red'><b>** Please Do Not Reply To This Email Account **</b></font><br>" text &= "<FONT color='red'>This message was generated...

I have a comment field (ntext) that I only want to display the record if something is populated in it. At the present time I have a bunch of empty boxes when I loop and it does'nt look to appealing. Question: How do I pull only the records that have something populated in them from a text...

...around. If (ID=11744) or (ID = 1215) or (ID=1217) or (ID=1218) or (ID=1219) Then arrTime = Split(ItemsWorked, ":") Itemsworked = arrTime(0) * 60 + arrTime(1) End If The users should enter in numbers in the format of 12:13, if they do the code work and sums up fine. If they enter...

Trying to validate a asp.net text box control that is within an asp repeater tag. Text box should only contain numeric values. It will not allow the user to submit the request, but the error message will not display. Code behind is VB. <asp:Repeater ID="rep_proc" runat="server">...

Okay, for Capacity and Time we have collect numbers one number for each employee every month. So all I do is order them within the detail section? Employee Capacity (Capacity_Rank) Time (Time_Rank) 1 77 2 6 2 2 88 1...

I have two fields I need to rank CAPACITY and TIME my grouping for the report is EMPLOYEE ID's. I would like the rankings to be in desinding order. I have tried multiple pieces of code, but with limited or no luck. The two fields are not summary fields. The numbers pull straight from a...

I'm using Cystal 8.5.. I have productivity scores for each of our 109 employess, the scores are from 77.03 - 99.59. My goal is to create a formula that would give a numerical ranking from 1 - 109 for each employee based on their score. I'm by far not close to an expert in Crystal, but...

Found it in search

I'm trying to find the time difference in seconds from two datetime values, EX: 2/20/2009 9:48:51 AM - 2/20/2009 9:50:51 AM. Any help in doing this in a query? Thanks..

I have an external Word file on a group drive that we want to link to from our web page. We need the file to open in Word because we have code in the Word document. How would I like this file from our page to open it. We are using Explorer 6.0 and Word 2003 Thanks for any and all help

Not sure if I have a clue what I'm doing. But, I know it's not working. I'm trying to pull quarterly data from one table. Summing up month 1,2, and 3 as Qtr 1 and 3,4 and 5 as Qtr2 and group by lastName: Table: LastName Firstname Queuescore Month ex; 1,2,3, etc SELECT SUM(QueueScore)...

I have a two tables a Review table and Account table with the relationship being the account number and note number. I want to return all records that exsist in the Account table, but are not in the Review table. Sounds easy, but I'm having difficulties. Thanks ACCESS 2003

I have two tables (Accounts and Accounts Paid) with the relationship being the Account Number and Note Number. I want to query all Accounts in the Accounts table that are not in the Accounts Paid table. Access 2003 Thanks, M

Having trouble running the below append query utilizing a union statement. Can this be done, if not any suggestions. Thanks INSERT INTO [R&R_MonthlyMatrixScores] ( BNumber, [Year], [Month], DepartmentID, Department, LastName, FirstName, Salary, IndPhoneMonitoringScore...

I have a Processdate field in a query:ex 4/12/2007. To build a relationship with another table I need to extract just the month value from the above Processdate string, that is I want to just return the "4". Thanks for any help. Mike

Need a little help. I need to convert a time string into minutes Example 144:58:12 would equal 8698 minutes. I'm really not worried about the seconds. Any help to get me started would be appreciated. Mike

Thanks SkipVought, another question, the check images have a back and front. All we need is the front portion of the check. Is there any code we could use to delete every other image from the spreadsheet? Thanks again...

Not sure how to accomplish this: We currntley export a report into word from an external application. The report contains up to 200.png check images, it also contains a lot of text that we have to go in and manually delete. All we want is the images of the checks. Is their a Macro we can...

I'm trying to write what I hope is a simple comparison statement. I have field called ProbEnd (End of Probation). We pay incentive if the employee has completed their probation and compltes other qualifiers. Below is what I'm trying to accomplish If the ProbEnd date is less than the 15th of...

Thanks MarcoAlan, worked like a charm. Any, idea on the sorting piece? Thanks again, Mike