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!

Search results for query: *

  1. 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...
  2. 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"...
  3. 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...
  4. nathanwiley

    Need to create formula for seperating out account numbers

    Ok, I work in energy assistance, and I use crystal reports to run error checks. My newest project is creating a report so I can check account numbers for accuracy. For example if a vendor has an account number like so "12-2254569891-215635489" 20 digits long including dashes. but if...

Part and Inventory Search

Back
Top