Search Result

mrdatabase1 · Apr 29 '12, 11:16 AM

I have this query and it works fine however i need the query to display the forename and surname and currently it only displays the max value of the sum it performs

Does anybody know what i can do?

Thanks

Code:

SELECT MAX(Intermediate.Total_Amount_Of_Likes) AS Total_Amount_Of_Likes
FROM (
SELECT Forename, Surname, Sum(Likes) AS Total_Amount_Of_Likes
FROM Instructors, Exercise_Class_Type, Exercise_Class_Staff,

...

NeoPa · Mar 19 '12, 08:17 PM

Introduction :

How many times have you come across the following error message when working within Aggregate, or Sum, queries?

What is this message relating to and how can one avoid it?

Aggregate (Sum) Functions :

These are the standard functions available to Jet SQL. I can't say no others can exist, nor that they may not be introduced later into Jet SQL itself, but these are currently...

Sandretto · Apr 19 '11, 07:42 AM

I have created a database to create and store purchase orders. My tables are as follows -
Tbl Order details (Qty, desc,price,tota l),
Tbl Order no (ON, date, date required, supplier)
Tbl Supplier (Supplier name, address)

I have created the Purchase order in form with subform. I am having difficulty getting the form to create a final total. I have tried '=sum([total]).

mutanic · Mar 22 '11, 01:07 PM

Hi Bytes,

I'm trying to get SUM of column "Price" base on selected item in column "Item". I've got no idea how to solve this without have to use sort & group function through SPD. This has to be a basic summary at the bottom of main list. I try to use $nodeset instead of $Rows but it become error. This is how I try to create the code.

Code:

sum($Rows/@Price[@Unit='Item1'])

This code got no error...

AccessUser123 · Mar 11 '11, 03:27 PM

Is there a function in Excel that will find which cells within a range that sum up to a predetermined value? i.e. I have a range of 1,000 cells with number values and I want to know which cells sum up to 467.

Adrian Tache · Jan 11 '11, 08:35 AM

Hi all, I'm having a serious issue with a sum returning double the amount it should.

I'm including the code below maybe you guys can see the problem:

Code:

SELECT clients.clientreadableid, Sum(projects.[total hours]) AS Hours


FROM clients, projects, timesheet


WHERE projects.clientreadableid=clients.clientid
And projects.projectid=timesheet.projectreadableid

...

brittany1 · Oct 21 '10, 12:37 PM

Please help i am geting a rounding up error when trying to multiply one calculated field by another.

Total Time
=Sum(([Time out]-[time in])*24)
Value = 24.34

Calculated Rates
=([price_material]*[quantity])/[Total Time]
Value = €10.68

Calculate Total
=[Calculated Rate]*[Total Time]
Value = €260.00 This should be €259.95

JohnnyB · Aug 11 '10, 02:32 PM

Hello All,

I'm still a SQL newbie so I hope this question is easy. I have to sum some transactional data and do a report on it. I used the SUM() function and found out that my totals were too high. I did an experiment on my data and just pulled a months worth and checked the sums for a couple of data categories within the month. The sum for the second one I looked at where I used the sum function was higher than the sum of the...

ORB30 · Jul 1 '10, 02:43 PM

Hi all,

Does anyone know how to work arround this problem of sum function in php?

The below query is giving me wrong results

SELECT

Code:

SUM(((kinisis_1c + kinisis_1e + ((kinisis_1c / kinisis_1b) * kinisis_1a))/(1 + fpa)) * 1.005) AS kinisis_1_total,
SUM(((100c + 100e + ((100c / 100b)* 100a)) / (1 + fpa)) *1.005) AS 100ara_total,
SUM(((super_1c  + super_1e + ((super_1c / super_1b)* super_1a))

...

MissE · Apr 15 '10, 09:59 AM

Hello Afternoon!

I've been trying to work out whats going wrong with my function for the last 2 days. I give up...

I have a main form (Infinity) with a command button which pops up a subform (Nominated) when clicked. The 2 forms are linked by a field called "Applicatio n ID".

The subform records the individual cash amount each employee has been rewarded - and this limits which employees appear...

MissE · Apr 8 '10, 02:05 PM

Hello Afternoon!

I've been trying to work out whats going wrong with my function for the last 2 days. I give up...

I have a main form (Infinity) with a command button which pops up a subform (Nominated) when clicked. The 2 forms are linked by a field called "Applicatio n ID".

The subform records the individual cash amount each employee has been rewarded - and this limits which employees appear...

JTB07 · Mar 31 '10, 07:49 PM

Hello,

I have a form that displays project information, and on that form is a subform that displays info about invoices related to that project. This info includes things like invoice number, invoice amount, status (y/n), etc. The subform is in datasheet view and gets its data from a query. I'd like to add three fields to the form that display totals from the items in the subform. These totals are:

-The sum of all...

Jordan218 · Mar 11 '10, 06:55 PM

Hi. How do I write a program that sums the digits of a 4-digit number? I have a program that works, but you have to input the digits separately. Can anyone help or possibly explain what I'm doing wrong? My professor told us as a hint to use the modulus sign (%), but i don't know how I would use that here. My code so far is below:

Code:

#include <iostream>

using namespace std;

int main(void)

...

ashukite · Feb 7 '10, 08:07 PM

I have two tables Invoices and Payments. invoices have payments. I want to write a query that displays unpaid invoices and the remaining amount of the invoice, which is calculated by summing up the payments of the invoice and subtracting it from the invoice amount. I tried this query but it doesn't work. please how can i do it.

Code:

SELECT Invoice.[Invoice Date], Invoice.Item, Invoice.Quantity, Invoice.[Unit Price], Invoice.[Payment Status], Invoice.[LongDate],

...

kyriacoullis · Jan 8 '10, 08:01 AM

hi there,

I have several forms that have a total field with the id gtotal1 gtotal2 gtotal3 ..... up to 35

I would like a Grand Total of those fields. I would like to SUM those fields.

I am looking for a code like:

If input id contains gtotal then sum that inputs value.. something like that.

I hope i was clear

Search Result

I Can't select the fields i need in the query result!

Aggregate Query Woes

How do i get a total from subform on purchase order?

How to get SUM of "Price" base on selected "Item"

Excel Formula Question

Issue with sum returning double the amount

When calculating time sheets/rates sum i get a rounding up value

Sum is too high

Loss of precision when using the sum() function in php?

Sum textbox from Subform on Mainform

Sum textbox from Subform on Mainform

How to display totals from a subform on a form

How to write a program which sums the digits of a 4-digit number?

Sql Subquery with sum

Sum inputs that id starts with