Search results for query: *

Skip I don't suppose it would be possible to figure out if it was a Saturday or a Sunday? I would also like to give any entry on these days 0's Also, I probably should have mentioned that first....my bad Trent

Saved once again by Skip!! Thanks man! Trent

Skip As per your request: Row |USER | PLACE | TIME | ACTION 1. |J. Doe |Datacentre | 6/1/04 8:06 | open 2. |L. Roy |Cabinet | 6/1/04 8:06 | open 3. |J. Doe |Office | 6/1/04 8:09 | close thru 567.|R.Handy |Datacentre | 6/30/04 19:04 | close Does this...

Hello All I have a spread sheet of the entrance/exits to our security areas over monthly period laid out as below: |User | Place | Time | Action | I need a formula that examines C2-Cx (a period that will cover from the start of the month to the end - 06/01/04 to 06/30/04), determines if the...

All I am running Outlook 2002 client on Windows XP and do not have much experience working with Outlook forms nor coding with Outlook objects. Here is my dilema. I have ~215 forms that have been returned to a personal folder. The forms are a simple survey with 3 user-defined fields (option...

All I am running Outlook 2002 client on Windows XP and do not have much experience working with Outlook forms nor coding with Outlook objects. Here is my dilema. I have ~215 forms that have been returned to a personal folder. The forms are a simple survey with 3 user-defined fields (option...

LB & KingfisherINC, I figured it out after a few rounds of trial and error, but thanks all the same, it helped me clean mine up. Another addition to the knowledge base I suppose. :) Thanks again! -TS

All I know that one of the FAQ's does have a formula like this: whileprintingrecords; numberVar dur:={TIME_TO_FINISH}(this is where error occurs) numberVar hrs; numberVar min; numberVar sec; stringVar hhmmss; hrs := Truncate(Truncate(dur/60)/60); min := Remainder(Truncate(dur/60),60); sec :=...

Howard I don't think it is my code, since it is pretty simple: datediff("s",DateTime (1970,01,01,00,00,01), currentdatetime) - {SHR_HELPDESKSLAS.TTA_SLA_TIME}( this is a Unix time field) The problem is that I don't understand, or can't figure out really, why the results of the...

Morning all Alright, I know this is something stupid and small, but I just can't figure it out. I have various reports I have been working on for weeks now, streamlining, aesthetics etc. This morning I have added a few new formulas yet whenever I try to display them on the report, with only a...

Good Day all I have been playing around with Crystal Reports Distributor (www.christiansteven.com) over the last few days, on a separate machine I have set up specifically for reports. I have no real problems with it, beyond a few glitches, and was surprisingly easy to setup and run. I was...

Still working on this...update: Thx Madawc for the help,but now I have run into an related problem that I think somone may be able to help me with. Can anyone see a reason why this selection formula would be timing out? //if monday, go back 3 days for info, else 1 day and greater if DatePart...

Hello All I have had no problems converting a Unix time stamp to DateTime for grouping and display in reports.(thanks to this forum, really, rather than my own reporting prowess) Now, I have begun playing with an automated report generator and exporter. Unfortunatley, I have no idea how to...

Skip/Bowser This forum never fails to help out! Thanks again for two quick and easy solultions! TS

Hello All I don't think this is too hard, but my formula/VBA knowledge has proven insufficient so far. I have a approx. 1800 records in a Excel Spreadsheet like this: User Name(col'm 1) John-Smith.Unit.Domain.Country I need to break apart the User Name...

Hello all I have a fair number (25+) of reports that have been created using Crystal 8.5 and have been running perfectly against a production server. We have recently added a reporting server, but I am having to use a different ODBC connection to get the data. I was using a Remedy ODBC b/c...

Skip Still working with the same sheets, books, records etc...the fourth column is a date modified column. How would I be able to pull individual records based on date last modified, and display them. A little more deatil on the format of my worksheets.... Colm A - File name; eg...

Skip Thanks a million, worked perfect!!! TrentSteel

Hello all I have what I think would be a fairly simple problem, but time is of the essence. I have 6 workbooks with anywhere between 15-50 worksheets per book. Column B across all worksheets and workbooks displays file size in bites. I need to sum all Col B’s in the various sheets, within...