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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

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

    ok i have a revised formula... {vwAVEAPApplications.ProgramYear} = 2010 and {vwAVApplications.ApprovedForEAP} and DateDiff(“yyyy”, {vwAVMembersAll.DOB}, CurrentDate) still get missing ) string... Thanks again for any help Nathan
  17. nathanwiley

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

    I am a newbie still, but I am stuck once again on a formula... I am wanting to take a table {vwAVMembersAll.DOB} and get the age of our families. I have started this formula but get an error of missing ) string. dateDiff("yyyy",(Date(CurrentDate){vwAVMembersAll.DOB} Thank you for your...
  18. nathanwiley

    Need to create formula for seperating out account numbers

    This isn't for an error report it is a different report that I didn't know to post new topic.. Thank you for your response.
  19. nathanwiley

    Need to create formula for seperating out account numbers

    I am in need of some more help... I need to make a report showing comparable data from previous years. We need to gather data showing an increase or decrease of income on the same report. Is this possible and this is what I have so far... I know its wrong but I can't think of for the life of...
  20. nathanwiley

    Need to create formula for seperating out account numbers

    Outstanding... Thank you SO Much... !

Part and Inventory Search

Back
Top