Recent content by CSADataCruncher

Thank you so much! This works! :)

I have a form that shows job entry data for last week's work only. I've recently added a command button that runs an "update query" on the table used in the form but, in order to see the new data created by the update query, I must requery or refresh the form. My problem is, when I refresh the...

I'm sorry... I don't understand. If you're trying to tell me there is already a thread that will answer my question, could you please point me to the particular thread/response?

I've created an update query that will update all records for a time period when the employee's name is selected from a list in a combo box and a command button on the form is pushed. I also added a "Refresh" macro to requery the form after update of a record. However, this is not ideal for...

Nevermind. :) Figured it out! Thank you, again! Peggy

Actually... almost perfectly. I forgot to mention that there are times when the e-mail address has an underscore rather than a dot. For instance first_last@domain.net. Is there a way to combine the formula you gave me with an if statement to determine if we are replacing a dot or an...

Brian, Oh Thank you, Thank YOU! I had been looking and looking. This worked perfectly! Peggy

I am using Crystal Reports XI and am trying to pull a name from an e-mail address and then reverse it as follows: e-mail field = first.last@domain.net And I want to display the name on my report as last, first I've tried split, right, left, mid... I know I'm close to a solution but I'm either...

WooHoo. Thank you, Ken, I figured it out. I plugged your formula into the detail line and then took the minimum from there rather than trying to have it do all the calculations including the minimum (if that makes sense to anyone but me). Anyway, it's working so now I'll just add to the...

Sorry... ignore that last part... I realized my error on the above formula. But now here is my problem. You may have noticed that I'm comparing an actual start date (and I have added the Date() function to the formula) to the "minimum" of an end date. What is happening is I have several times...

Thank you, Ken, I tried both formulas (here is what the main formula looks like: WhileReadingRecords; Local DateVar Start := {@SRCreated}; Local DateVar End := Minimum ({v_TimesheetDetailReview_CSA_Dept.StartDate}, {v_Incident.IncidentNumber}) Local NumberVar Weeks; Local NumberVar Days...

I'm currently calculating the interval between two date fields in our database. However, now I've been asked to exclude holidays and weekends. Here is my original formula for just the plain date calculation: DateDiff ("d",{@SRCreated},Minimum ({v_TimesheetDetailReview_CSA_Dept.StartDate}...

Thank you so much for all your help!!! I'm sorry it took me so long to finalize the things we worked on together but I took a vacation in between. Today I noticed another post with a similar problem that you had responded to and, for some reason, everything finally clicked for me and I was...

That coding is giving me a few errors... first it said a field was unknown {@Cost} So, I tried changing it to {@ReimbCost} but then the error message said it was expecting a number and highlighted the entire line of the code. So, I changed it to take out the word "maximum" (as each timesheet...

LB, For the most part it's standard @ $0.40/mile. But we do have one group within our company that is reimbursed at a higher rate - they are not currently on this database system and we add them, I think I can handle that coding to change the rate for a specified group. The only other time...