Search results for query: *

Hi all, I tried to search for this and didn't get anything. I am sure I am searching wrong as I am certain this is a common question. I am running this expression in my query and it is telling me the expression has invalid syntax. Does anyone know what I am doing wrong. I have not used...

lbass, thanks for the suggestion on the cross tab. I will do that and makes things easier for me. I am saving both versions of the code above for future reference. Thanks again to both of you

Thanks to both of you. the problem with making this one field and then grouping on it is that I already have a group placed in the report. I need this to appear as columns and not groups. Ironically enough, I did both of your formulas and they worked. I then tried to create a single field...

Hi all, I am using Crystal Reports 11. I do allright with formulas until I start using date formulas. They confuse me so much that I sit there paralyzed looking at my screen and not knowing what to do. :o( I have to create a report that uses three forumula fields based upon date range...

My co-worker is working on a spreadsheet here is the dilemma. I am hoping someone here can help. Thanks as always I have embedded an excel table within a word document. I created a macro to unprotect the workbook insert a row in the proper place and re-protect the workbook. Is there a VBA...

I KNEW it was going to be something that simple but coudln't figure it out for the life of me. Thanks, it worked like a charm!!! :)

Hi all, I am sure there is a simple formuala for this but I can't figure it out (I looked in my Crystal book and have been googling for 1/2 hour.) Anyhow, I have an account number that is stored as text. For security purposes I only want to show the last four digits. Is there a text formula I...

Thanks Glenn, I never knew you could do that with Paste Special. Very cool and it worked like a charm.

Doh, sorry. That would help (multi tasking here).[blush] It is in an excel spreadsheet Thanks

Hi all, I have two fields. One is called Mat Date and the other is Est Mat Date. My problem is that the two fields basically mean the same thing but are in two seperate fields. Whenever there is a date in the Mat Date field than the Est Mat Date field is null and vice versa. What I need...

Thanks both of you. All I need is the date and time it was revised. It would be whenever anyone changed text or numbers on the spreadsheet, or whenever anyone added a row or column to the spreadsheet. I did a test run on one of my sheets and it seems to have worked just as I wanted it to...

Hi all, one of my co-workers is trying to figure out a way to have a date on a cell that will show the last revised date, not the current date. Is there a simple formula that will do this? I googled and searched but couldn't find anything. Also, It would be when a change was made and saved on...

It would be when a change was made and saved on a worksheet and it would be on a worksheet or a row (if that makes sense). Sorry I am getting this second hand and the end user is an Excel Newbie. Thanks again.

Hi all, one of my co-workers is trying to figure out a way to have a date on a cell that will show the last revised date, not the current date. Is there a simple formula that will do this? I googled and searched but couldn't find anything. Many thanks

Thanks, that worked

Hi everyone. I am using Crystal 11. I have created a report that has some formulas in my first group. I would like to change the group on the report frequently dependent upon who the report is going to. Anyhow, after I change the group, I get an error message that says "there must be a group...

Correction: dgillz helped me with this formula. lbass helped me figure out the one over the weekend. Is there any way you can edit your previous posts on this forum?

OK, I have spent most of my day trying to figure out how this can be done. I have googled arrays and variables and still can't figure out if this is what I need to create in order to get my report to look the way I need it to. Here is the scenerio. I have a report that shows two years worth...

Okay, I now have another dilema that is somewhat related to the date range question above, but it is a little more complex. I have created a series of formulas based on the formula above and the dates I needed it for for my sale field. I was bascially looking at sales for different time...

Thank you dgillz That worked like a charm!