Recent content by CrystalKim

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