Search results for query: *

Hello! I really need your help! Ideally, the code should open specific directory (folder). Loop while opening all the Excel workbooks inside the folder. Copy “sheet1” from each workbook and paste it onto my active work. The worksheet should be copied using PasteSpecial...

Hello, I am an active Tek-tip site user requesting help. This time around, I am trying to meet a deadline( I have researched for hours). I am willing to send you a e-card in the amount $40 from Amazon.com, if I star your post. I will be very very grateful!!!!! On Crystal reports: GROUP 4...

Group Header Won't Repeat on Next Page even when Properties set to "RepeatSection" = "Yes". Any help will be greatly appreciated!!

I need to hide detail section (eliminate space) if specific field is null.

On MS Access 2007, I am attempting to hide Group Header 2 if detail is blank. Also, it would work if I could hide the group based on specific text field being Null Thanks!!!!

On MS Access 2007 Report, I am attempting to hide Group Header 2 if the detail is blank for that specific group. Your help will be greatly appreciated, I am working against a deadline. Thank You!

Hello, I have field or manufacturing weight in decimals, and I need to convert to pounds and ounces. in this format: 10 lbs and 5 oz. This is a two step process: a)convert decimal to pounds b)format format: "10 lbs. and 5 oz." Any help will be greatly appreciated!!!

I'v tried several formulas and they don’t seem to work. I am trying to convert a five digit character string “12345” into a date field "mm/dd/yy" Any help will be greatly appreciated! MochaLatte

I need to select records (visitors) based on specific months and count numb days of stay. For example, I need to select all visitors who stayed in our facility in the month of July and calculate the number of days/stay in July. Visitor A : Visit begins in June 15 and Visit ends in August...

I am trying to display only the patients who had a change in class (Joker and Bear in the example below). Any assistance will be greatly appreciated!! USER ID : 12345 NAME CLASS JOKER Yellow JOKER Yellow JOKER Green USER ID: 15687 NAME CLASS BATMAN Blue BATMAN Blue BATMAN Blue USER ID...

How can I flag users who had a change in Class? I am grouping on USER ID Thanks!!!! USER ID : 12345 NAME CLASS JOKER Yellow JOKER Yellow JOKER Green USER ID: 15687 NAME CLASS BATMAN Blue BATMAN Blue BATMAN Blue USER ID: 55555 NAME CLASS BEAR RED BEAR...

Hello, I am a Crystal report developer without any experiencing on programming. Any recommendations on a book that explains the basics of an array and how it applies to Crystal reports. Any is greatly appreciated!!!

I have a report that is grouping records by USERS. I need to display the following info on each user SELECT ONLY RECORDS WITH ALPHA OR GAMMA TEST TYPE ONLY AFTER SELECTING ALPHA OR GAMMA DISPLAY THE FIRST TEST TAKEN DATE AND TIME and TEST TYPE USER TEST TAKEN...

Hello, I have a report for patients each patient has different diagnosis. For example: (Detail Section) Patient A Chest Pain Patient B Cough Patient A Chest Pain Patient B Nausea Patient B Nausea Patient A Headache I need to concatenate diagnosis in the footer into a single field, it...

I will apreciate any help creating the variable to solve the following issue: I have the following data grouped by Employee Name Employee Name Test Taken Date Mike, Moose 1/6/2011 20:22 1/7/2011 5:42 1/8/2011 6:25 1/8/2011 20:03...