Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Cozmo2

  1. Cozmo2

    Add if greater than/equal Start Date And Less then/equal Stop Date

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

    Decrypt Data

    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?
  3. Cozmo2

    Access pass-through query using a form for parameter

    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)
  4. Cozmo2

    Access pass-through query using a form for parameter

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

    Access pass-through query using a form for parameter

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

    Access pass-through query using a form for parameter

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

    Access pass-through query using a form for parameter

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

    Access pass-through query using a form for parameter

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

    Access pass-through query using a form for parameter

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

    Access pass-through query using a form for parameter

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

    Access pass-through query using a form for parameter

    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 +...
  12. Cozmo2

    How to separate summarized fields in a Cross-Tab report?

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

    Drill Down or Show Section Based on Variable

    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?
  14. Cozmo2

    Drill Down or Show Section Based on Variable

    When I do that the Drill Down does not work.
  15. Cozmo2

    Drill Down or Show Section Based on Variable

    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?
See more

Part and Inventory Search

Back
Top