473,503 Members | 2,107 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need Help with an Access Calculation in a Report

12 New Member
Need serious help with a calculation. The fields are based on a query that has linked many different tables. The calculation I currently have is:

=sum([QtyProduced])/(([runtime]+[downtime])*(Piecesnum]))

It is giving a calculated outcome, but an incorrect one. I am basically trying to get the QtyProduced to divide into the combined runtime+downtime*piecesnum to get a sum of efficiency. I've tried many different combinations of this calculation, but have had not luck. Any suggestions would be truly appreciated.
JLF
May 17 '06 #1
5 4268
wlc04
70 New Member
Try this:

=sum(([QtyProduced]/([runtime]+[downtime]*[Piecesnum]))
May 17 '06 #2
jlf
12 New Member
Try this:

=sum(([QtyProduced]/([runtime]+[downtime]*[Piecesnum]))

Wendy,

Thank you, this worked great.
jlf
May 18 '06 #3
jlf
12 New Member
=Sum([qtyproduced])/((Sum([qtyruntime]+[timedown])*[piecesperhour]))

The suggestion from Wendy was actually still giving me incorrect data, but still appreciate the suggestion. The above formula fixed the issue completely.
May 18 '06 #4
wlc04
70 New Member
OOPS!! Sorry about missing the sum, but I'm glad you figured it out. :o
May 19 '06 #5
jlf
12 New Member
OOPS!! Sorry about missing the sum, but I'm glad you figured it out. :o

No worries.....you're great. JLF
May 19 '06 #6

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

Similar topics

2
5923
by: Simone | last post by:
Hello. I am using the code below: ------------------------------------------- Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Section(0).BackColor = vbWhite Then...
3
3683
by: CSDunn | last post by:
Hello, I have a situation with MS Access 2000 in which I need to display report data in spreadsheet orientation (much like a datasheet view for a form). If you think of the report in terms of what...
2
2541
by: Rick Caborn | last post by:
I am having a problem with an Access 2000 report getting data from SQL Server 2000. Here are the specifications for it: RecordSource: a stored procedure (tested via query analyzer and working...
4
4186
by: Richard Sherratt | last post by:
I've got a TextBox in a page header that I'm using to print a variable report header field that reflects the parameters selected for the report. I'm using a TextBox rather than a Label so that I...
2
5430
by: CSDunn | last post by:
Hello, I have an Access 2003 report that opens in print preview and then maximizes upon clicking a button from a form. The OnClick event of the button fires a macro to open the report. How can...
1
1504
by: jlf | last post by:
Need serious help with a calculation. The fields are based on a query that has linked many different tables. The calculation I currently have is: =sum()/((+)*(Piecesnum])) It is giving a...
1
1874
by: Susan-MN | last post by:
I’ve just recently started working with Access at my new job. I’ve been able to figure out quite a bit on my own, but I’m stuck with a problem I can’t seem to find answer to on the Access help or...
1
2358
by: Gilberto | last post by:
pks00 Expert 280 Posts April 16th, 2007 01:08 PM Re: How to print MS Access 2000 report to PDF995 printer by VBA Code Sweet, your using pdf995, makes answering this question that much...
13
2184
by: anthony | last post by:
I'm creating a report that will present information split into several sections with each section dealing with a particular aspect of data. No problem there. However, one of the sections will...
0
2215
by: cbj0517 | last post by:
Hello: I am trying to create a Pivot table in an Access 2003 report. I have SQL that retunrs 6 columns of data, (month_year, units, products_per_unit, gross_sales, price_pe_product, and...
0
7287
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7011
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7468
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4689
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3180
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3170
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
747
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
401
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.