473,324 Members | 2,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Format Percent

Hello -

Im trying to calculate a total % for my employees production. I have one table (TechProduction) that contains 2 columns (Production) and (Fails)and in my report I'd like to be able to see a percentage for total production, attached is a picture to give a better understanding. The formula I currently am using is

Expand|Select|Wrap|Line Numbers
  1. =FORMATPERCENT(DCOUNT("[ID]","[TechProduction]","[Production]")/[Fails],2)
However it is not working.. Ideally, I'd like to just use the numbers generated from the two text boxes to the furthest left of the ones showing the formulas i've tried, the name of those boxes is (Prod)and (Text41). Those text boxes are the totals of production and fails generated from the sum of the production and fails in the report. However, everytime i have tried to do a sum(prod)\(text41) it delivers a pop up that i manually have to enter the numbers upon running the report. Please let me know if i need to explain a bit further.

Thanks in advance,
Daniel

Attached Images
File Type: jpg Error.jpg (47.8 KB, 299 views)
Jul 24 '14 #1

✓ answered by twinnyfo

Instead of "Sum(Prod)/Text41", try "[Prod]/[Text41]"

4 1674
twinnyfo
3,653 Expert Mod 2GB
Instead of "Sum(Prod)/Text41", try "[Prod]/[Text41]"
Jul 25 '14 #2
twinny - I see what you mean there. I tried that and it still didn't work. However, it put me down the right path. After doing this I created 3 more text boxes, these boxes just took the sum of 3 different columns. I then made them not visible and performed the operation from those text boxes and it worked..I guess it didn't like it when I did math from one box and had another one relying on the math of the first one. I know that sounded very confusing..basically as soon as I gave it a number to pull, instead of an equation it worked.
Jul 25 '14 #3
twinnyfo
3,653 Expert Mod 2GB
Glad to hear that you could work this one out. Have a great weekend!
Jul 25 '14 #4
NeoPa
32,556 Expert Mod 16PB
Your reference to DCount() in :
Expand|Select|Wrap|Line Numbers
  1. DCOUNT("[ID]","[TechProduction]","[Production]")
is not correct. Check the Criteria parameter.
Jul 26 '14 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Alex | last post by:
Here's a tricky SQL question that has definitely driven me to the end of my rope. I'm using Oracle 9i and I need to perform some simple multiplication on a field and then display it with a percent...
4
by: MX1 | last post by:
Hi all, I've setup a table with one field that will hold percent values. The type is number and the format is percent on the field. When I do data entry directly into the field, I have to put...
1
by: Terencetrent | last post by:
I am trying to format a query expression drawn from a dialog box as percent. The original statement to get the value for the query is as follows: New%markup: !! The dialog box looks the...
3
by: Nothing | last post by:
This is going to be a really stupid question, but I am having a problem with the percent format in a control on a form. My end goal is that I want the user to enter 17 and have the control...
1
by: Alan Lane | last post by:
Hello world: I'm having trouble finding how to escape the percent sign ("%") from a SQL query so that it will show up in an Access report. Here's my SQL string ... '--Build SQL String...
3
by: ronrsr | last post by:
is the error message I'm getting here, on the long formatted print statement. . I've tried adding arguments, in case I missed one, and it still gets a syntax error. here's the info: #row is...
3
by: shill57957 | last post by:
I have a query: SELECT .AH_TICKNO, Format((.AH_AMOUNT-.AH_TRNAMT)/.AH_AMOUNT,"Percent") AS DIF INTO FROM ; I dont want to format as a percent, I want it to go into the table with 4 decimal...
1
by: parthis | last post by:
Hi, I am new to Access and working a Report to display a Percentage value. The value in db is a text with value 23 But when i apply Format = Percent in design view of Reports it renders it...
4
by: plaguna | last post by:
Every time I calculate numbers to get a percent format type in a query It gives me a big number. For instance: 7689.43% instead of 76.89%. I tried every possibility in the Property Sheet and It...
4
by: morganaj | last post by:
Hello, I am trying to use this form: http://i.imgur.com/06RWh0Y.jpg to select a program type and generate a random list to audit. This part is working correctly. But I would like to use a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.