Search results for query: *

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

...NumberVar Days; Local Numbervar Hol; DateVar Array Holidays; Weeks:= (Truncate (End - dayofWeek(End) + 1 - (Start - dayofWeek(Start) + 1)) /7 ) * 5; Days := DayOfWeek(End) - DayOfWeek(Start) + 1 + (if DayOfWeek(Start) = 1 then -1 else 0) + (if DayOfWeek(End) = 7 then -1 else 0)...

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

...currencyvar addcost; if sum({@miles},{timesheetexpenses.ExpenseDate}) >= 30 then micost := (Sum ({@miles},{timesheetexpenses.ExpenseDate})-30)*{@ReimbCost} else micost := 0; addcost := addcost + micost; micost; but this only adds the last line's reimbursement. So, I started over, copying...

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

...on one fact... it's not the total miles that I will be bringing forward, it is the reimbursed amount which would be {timesheetexpense.cost}*{@miles} but I can't seem to get it to figure right. I figured once the mileage was calculating correctly (which it is now thanks to your wonderful...

LB, I'm sorry, you're right, that would be helpful. A little background... the database I'm using is a CRM database that is online. So, I cannot change the database structure too much. That being said, Yes, the timesheet number is unique not just for the week but also for the employee...

LB, Yay, I'm/We're getting closer... at least it's no longer a zero. :o) I modified the coding just slightly and it seems that I do need to clear up a few misconceptions because the code isn't working entirely the way we need. This is my current results: Mon, 6/22/09 343 313 $125.20 Tue...

Thank you LB, I'll give this all a try shortly... So, the first one (@mileage) would still go in the date footer? or in the details? Because I currently have the details just showing me the mileage expense. But, as mentioned, I trust you, and logically it seems correct what you have said, so...

I'm feeling a little dense right now because I just can't seem to figure out how to use variable fields properly and I'm fairly certain that variables are exactly what I need to accomplish my goal. So, here is my goal. I'm creating a report that tracks an employee's weekly time and expenses...