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?

If I put the statement in quotes like this: WHERE approg.entry_date >= '#[Forms]![ParameterForm]![EntryDate]#' AND approg.entry_date < '#[Forms]![ParameterForm]![EntryDate]#' + 1 I get Conversion failed when converting date and/or time from character string (#241)

Now I get Incorrect syntax near 'Forms'. (#102)

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 + ' ' + address.zip AS CtySTZip, address.e_mail, address.e_mail2, address.phone, address.cell_phone, nmprg.prg_cod, dispos.disp_date...

Received Incorrect syntax near '>'. (#102)

I received the error message 'Int' is not a recognized built-in function name. (#195)

It is formated as 'Short Date'. The field I am comparing it to is a date time field. How can I change it to only date, I tried date(approg.entry_date) but access didn't like that.

The form has a Text Box for the person to enter the date. They then click on a button that has an event to run the query.

Any idea why it does not like the approg.entry_date = [Forms]![ParameterForm]![EntryDate] statement?

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

Right now I am creating two reports. 1 to show all the GF4 lines and one to first show a Summary Page then drill down to student type then drill down to the award then drill down to the student receiving the award. I was hoping for a more efficient way. Any thoughts?

When I do that the Drill Down does not work.

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?

That worked! Thanks you so much.

I made the change to the report options and ran into more problems. I am using a excel spreadsheet as my input table and it is creating many headaches! I think I will make a running total for the 'open house' and one for the 'Blue Chip' and add the two together at the end. Thanks for the...

Yes. That is what is happening. If I change the order: {State} = "IL" AND {Type} = "FR" AND ((cdate({Blue Chip}) <={?AS OF Date}) OR (cdate({Open House}) <= {?AS OF Date})) I get the count of students with the Blue Chip date but not the Open House date.

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