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 Rhinorhino 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 nathanwiley

  1. nathanwiley

    Matching Billing Names with matching Elderly and or Disabled status

    Sorry about the "True" I am still learning... I placed the code you sent and it didn't show errors, but you knew that cause you are a pro :), that aside it is still pulling households who are not disabled. Resulting in more data than needed. I will call it a night, I have gotten further with...
  2. nathanwiley

    Matching Billing Names with matching Elderly and or Disabled status

    Ok I tried this and I have good success until I enter OR instead of AND after age. {vwAVEAPApplications.EAPApplicationStatus} = "Approved" and {vwAVEAPClaims.VendorName} = "Duke Energy" and {vwAVEAPApplications.ProgramYear} = 2011 and {vwAVEAPApplications.MatrixPoints} >= 12 and {@AGE} >=...
  3. nathanwiley

    Matching Billing Names with matching Elderly and or Disabled status

    I will try, thank you!
  4. nathanwiley

    Matching Billing Names with matching Elderly and or Disabled status

    I was checking, and our criteria can be either elderly or disabled or they can be both, they just have to be older than 18.
  5. nathanwiley

    Matching Billing Names with matching Elderly and or Disabled status

    thank you! We have over 1400 families already todate, is it possible to formulate it to just show the ones that match with the formula you provide?
  6. nathanwiley

    Matching Billing Names with matching Elderly and or Disabled status

    Hello, I have a challenge again... I have the following tables. {vwAVMembersAll} {vwAVEAPApplications} {vwAVEAPClaims} I need to pull specific data, let me explain... I work for the Energy Assistance Program that helps pay on qualifying families on their utility bills. I have new funding...
  7. nathanwiley

    Help on Sorting claims provided

    LB, It worked, and found an additional one the "command" didn't. Thanks for your expertise... :) :) :) Thanks so much!!
  8. nathanwiley

    Help on Sorting claims provided

    I will attempt this, but I was told "is very difficult to do this type of report using the standard feature in Crystal. Being a programmer, Matt can work around that using his advanced knowledge" They attached a report, but when I open it, I can't see any forumla except "command" when I go...
  9. nathanwiley

    Help on Sorting claims provided

    Sorry - Second Question "or do you mean to test ALL fuel types for the absence of an electric claim?" Answer - If any heat source is used except electric. (Our program requires an electric claim with a heating claim, if a heating claim has no electric claim then it could be a mistake) I hope...
  10. nathanwiley

    Help on Sorting claims provided

    Yes it is a heating fuel, but for the families who heat with something other than electric, they are to receive a benefit on both gas and electric, if they received a benefit on the heat and NOT on the electric there is an error or those files need to be monitored for quality assurance...
  11. nathanwiley

    Help on Sorting claims provided

    Hello again, I am needing help showing / sorting out claims not given. We provide assistance to households who heat with GAS, ELECTRIC, but if we provide a benefit to the GAS and not the ELECTRIC I need to know because you can't get help without an ELECTRIC claim. "without special approval"...
  12. nathanwiley

    I am in need of a Formula for Datediff - missing ) string

    Ok, I told you I was a noobie, but I didn't place the forumla provided in the correct place. I relized my mistake and then added under the formula field a new formula named (age)... thus - DateDiff("yyyy", {vwAVMembersAll.DOB}, CurrentDate) worked perfect. Thank you sooo much again sorry...
  13. nathanwiley

    I am in need of a Formula for Datediff - missing ) string

    Only thing I could find, I do access crystal though a state server so some options may be grayed out... SELECT "vwAVEAPApplications"."ProgramYear", "vwAVMembersAll"."LastName", "vwAVMembersAll"."FirstName", "vwAVMembersAll"."IsHOH", "vwAVEAPApplications"."ApplicationKey"...
  14. nathanwiley

    I am in need of a Formula for Datediff - missing ) string

    Sorry, here is what I want to do... We work with a seasonal program and now we are approaching summer, and our new program only allows us to help specific groups, Elderly, disabled, and families with children under 6. So the table I have is {vwAVMembersAll.DOB} I don't have any other...
  15. nathanwiley

    I am in need of a Formula for Datediff - missing ) string

    Skip, I tried this dateDiff("yyyy",(Date(CurrentDate) , <---- {vwAVMembersAll.DOB}) and where its bolded says missing ) string
See more

Part and Inventory Search

Back
Top