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)...
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...
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...
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
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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.