Recent content by Cozmo2

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?