Search results for query: *

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

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

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

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

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

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