Recent content by Jewel142

Okay - I think I figured out what was wrong. The calculated days should be a SUM and I believe it's only pulling the last field in the report in. That being said. I fixed my formula so that I am now calculating correctly. datevalue({EMPLOYEE_1.New_Rehire_date})-sum({@Calc_Days}) WooHoo...

The {EMPLOYEE_1.New.Rehire_Date} is a date field. I validated my formula in Excel for example: Rehire Date 7/19/2011 - Days previously Worked of 320 should give me a returned date of 9/2/2010 instead I am getting a date of 02/19/2011 which isn't even close

I even tried using the DateAdd function: DateAdd("d",-{@Calc_Days},{EMPLOYEE_1.New_Rehire_date}) but it still doesn't won't work. Thanks!

I am trying to calculate a date in Crystal. What need to do is calculate number of days previously worked and minus from their rehire date calculate a combined length of service date. My calculation is working properly but I can't get the date to calculate correctly. Here is my formula...

Thank you - it worked! Jewel

I am new to SQL and I'm having a hard time with getting the right results from my subquery. I am reporting off of three tables, Vendors, Invoices and Line Items and I am trying to get the results for each invoice that has more than one line item in the InoviceLines Table. Here is my code so...

Thanks I'll give that a try!

Hi Everyone, Is there a way to limit the types of characters in a user input box (not a text box). I have a text box that I use for capturing social security numbers and have a key press event set up so that they can only enter numbers. However, if they enter less than 9 characters or skip...

Try opening the file in PDF and they copying the text directly from the pdf file (you should have a flashing cursor and should be able to highlight and copy your text). Then just paste it into your word document. This also works if you need to put it into excel and then use your text to...

Hi Everyone, I've just started working with arrays and I can't seem to get it to work properly. The first item saves just find but my array keeps overwritting itself. Any suggestions? ----------------------- 'Declare Arrays A_{Array Name} Private A_EE_NBR(0) As Integer Private...

Yes it did! Thank you so much! Is there a really good reference book out there that you can recommend? I've looked at a couple of them but I'm not sure which one to get. Thanks again and have a great day! Jewel

Thank you so much. I will let you know how I make out. Thanks again and have a great day! Jewel

Hi Everyone, I have a program that I need to convert a dollar amount to Euros. I've done the background calculations computing from dollars to euros. I can get the proper amounts to show up in my listbox items but I'm having a hard time figuring out how to swap the decimals and the commas...

This may be a long shot but have you tried subreports?

Can you provide us with a print screen so that we can see what you are trying to accomplish?