Search results for query: *

I need a formula to count # of majors for past 5 years by school year. For example if a major has a start date of 4/27/17 and the stop date is null I would need to count the major in the school year 8/1/2017 - 7/31/2018 and the school year 8/1/2017 - 7/31/2018. Also if a major has a start...

We have a field on our database the is encrypted. I need the value of the field (not encrypted) to print on my report. How can I decrypt the field?

I am using Access 2010 and am trying to execute a pass through query from a form where a date in entered. The query looks like this: SELECT RTRIM(name.last_name) +', ' + name.first_name AS Name, name.soc_sec AS ID, address.st_addr, address.add_addr,RTRIM( address.city) + ', ' + address.state +...

thread149-475411 I am doing a cross-tab (Crystal 9.2.2) with two summarized fields. They end up in the same cell. Is there a way to separate the summarized fields into two columns? The thread1490475411 says it is possible but I could not find the steps I needed to take. Thanks

Is there a way to either print a line or make it available via the drill-down option by passing a variable. For example, if stringVar PrtHdr = "yes" show section else make available with as a drill-down?

I am using Crystal 9.2. I want to add a running total to my report that counts the record if the state = "IL" AND the Type = "FR" AND either the open house date OR the Blue Chip date is less than or equal the AS OF DATE. I am using the formula below and it will only add to the count if Open...

I am trying to pass numeric (date) data from the main report to a sub-report. If the date is empty CF converts it to an alpha value. Where and How can I change the date to 1899-12-30 if a valid date is not returned. I've tried many things (functions, in the query, etc) and can't get anything to...

I am using Crystal 9.22.634. I have a database file with student names and the name of their picture. For Example: John Smith 123.jpg The pictures are located in a different area of the server. Is there a way I can add the picture to my report?

Using the Select Expert I have both a record select and a group select. The record selects records with a GPA > 3.5 the group select selects records with "Sum ({nmcrs.cred_rec}, {@Concat Name}) >= 12.00". When I use the 'Insert Summary' feature the total given includes the students that were...

I am using Crystal 9.2. I have a report that gives a blank page if no data is returned. I would like the Report Header, Report Footer and the Page Footer to print even if no data has been returned. Thanks for you help.

In the mail merge feature in Word 2010 how would I print a portion of a field? I have a mergefield called 'termint' with a value of YYYYMM. I want to print only the YYYY portion. Thanks in advance for any help you can give!

I have Word 2010. I created a org chart using 8.5 x 14 paper. I am now told that the paper has to be 8.5 x 11. Is there anyway to shrink the chart so it fits on 8 x 11. Any help will be appreciated.

I am trying to retrieve all the Friday and Saturday dates between two datetime fields (2/18/2011 - 3/19/2011). The output needs to look like: February 18 - 19 2011; March 4 - 5 2011; etc. I am using Crystal 9. Any help/advise would be greatly appreciated.

I have Crystal 9.2. I have to take the number found in a memo field and write it out (24.5 would be "twenty four and one half hours"). I thought if I could locate the decimal I could print the numbers on either side. Any help would be appreciated.

I have Crystal 9. I have a string parameter field that contains school year. 200910 represents the 2009 & 2010 school year. I want to create two formula fields (must be datetime fields) from this parameter. I defined one as: dateTimeVar PgmStart:= CDate(val(Left({?Interest Year},4)),08,01) +...

I need to have a mail merge that will print only certain activity codes, sometime the activity code has to have a certain dept code. For example: Run 1 Print all the records with the activity code of "LLL" Run 2 Print all the records with the activity code of "XXX" and dept code of "22". The...

I would like to group by a summary field, however it is not one of the fields I can select when grouping data. Is there any way to do this?

I have an input field [Zip] defined as a string for a length of 10. I need to move the first 5 characters to a numeric field [PermZip](length of 5). I am using a append query. Any help would be appreciated.

I have a form that has data & several command buttons that open other secondary forms. I want to put a field from one of the secondary forms onto the primary form. What is the best way to accomplish this? Thanks for any help you can give me.

I need to find the average of a range of numbers after elimating the highest and lowest numbers. Any ideas? Thanks