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!

  • Congratulations Westi 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. djunkins

    Help - Emailing a Report

    I designed my Form and my Report to look the same, to be user friendly. I've added an email button so when someone fills out the form they can send that report. The problem is that ALL records of the report are sent and it's only text, no lines that separate the fields. How do I send (email)...
  2. djunkins

    Help w/query and charts

    This is the field i'm having trouble with, when charting. Field: WkBeg: [Date Submitted]-Weekday([Date Submitted])+1 Total: Group By Critera: Between [Forms]![charts]![StartDate] And [Forms]![charts]![EndDate] I then go to charts wizards, add the fields, %of good parts, Goal of 99%, and...
  3. djunkins

    Trouble w/charting

    This is the field i'm having trouble with, when charting. Field: WkBeg: [Date Submitted]-Weekday([Date Submitted])+1 Total: Group By Critera: Between [Forms]![charts]![StartDate] And [Forms]![charts]![EndDate] I then go to charts wizards, add the fields, %of good parts, Goal of 99%, and...
  4. djunkins

    Help - query %

    THAT IS SO TOTALLY IT !!! Geez, I've tried so many other formulas. People had me writting codes so long, I knew it had to be simple. Thank you very much!!! Dan
  5. djunkins

    Help - query %

    Thank you, but that's the same results i'm getting already. I have the percent of bad parts. I'm trying to get the percent of good parts. example: 10 bad parts, 90 good parts = 90% good parts. In excel this is a piece of cake but the formula does not work the same in access.
  6. djunkins

    Help - query %

    Please help. I know that [BadParts]/[GoodParts] =%of BadParts. I'm trying to get the % of goog parts. I've tried several formulas in the critera but nothing seems to work. Can Someone please help me. Thank you, Dan

Part and Inventory Search

Back
Top