Summing Rows?

Nov 13, 2006

Hello All

I am making an attendance program for my college. When a user swipes their ID a record is set in an Access database. The column headings are the users name, classID and so forth followed by a column for each week of class. What I need to do is write a dynamic query that will sum the the values through the weeks for a particular student. Any suggestions?

View Replies


ADVERTISEMENT

Reports :: Summing Up The Rows In A Column?

Mar 20, 2013

How do I sum up the rows of a column in a report ? My example is here below

Sick Days
Employee1
Employee2
Employee3
Total of Sick Days

View 1 Replies View Related

Queries :: Summing Columns Into Multiple Rows?

May 13, 2013

I have a linked table. The table looks like:

Course 1 Name | Course 1 Grade | Course 2 Name | Course 2 Grade |
Student 1
Student 2
Student 3

I need to write a query that will consolidate all the courses (15 total) into multiple rows like this:

Course name | Course Grade
Student 1
Student 1
Student 2
Student 2

What is the best way to do this?

View 8 Replies View Related

Modules & VBA :: Summing Multiple Queries And Summing Time

Oct 4, 2013

I have a sales form. The sales form has many Call, Meetings and Emails linked to each sales record. I want to total all the number of calls, meeting and email records related to the sales record to give a total- Touches.I've created 3 queries;

1 - Counts Calls
2 - Counts Emails
3 - Counts Meetings

These all work fine however when I combine them to attempt to count the results it doesn't produce the correct results.I have a second query as well (no pun intended).

I am trying to sum together a column that has values in Time. The results displays as a decimal. How can I have the result display as a Time i.e. 1:20 (1 hour 20 minutes).

View 1 Replies View Related

Compare Several Hundred Rows Against Other Rows

Nov 21, 2005

Not sure if what I want to do is possible, or at least possible the way things are set up.

I have a massive table - c. 6 million rows. It contains data along these lines:

Plan#, Item, Price, Description, Colour, Value, Location, etc.

The primary key would be Plan# + Item. Each Plan# has approximately 1,000 Items, and there is only 1 Item per Plan#. There are only a limited number of Items (c. 1500) and all or only some Items might be assigned to the Plan#. All items under each unique ID# belong together, sort of in a set. So this huge table has approx. 6,000 unique sets (based on Plan#).

To add to the confusion, Item A under Plan#1 may have different information (Price, Description, Colour, etc.) from Item A under Plan#2. I know this isn't a great way to set up data but this is what I have to work with.

Over the years it's possible that the exact same combination of Items with identical values might have been set up for multiple Plan#s. What I need to do is find any Plan#s which have the exact same combination of Item, Price, Description, etc. So if Plan#R has 200 rows and Plan#S has 201 rows, it automatically doesn't match. If Plan#R has 200 rows and so does Plan#T, all information in each record must match between the two Plan#s (with the exception obviously of Plan#).

I don't think this is possible, and if it is I am sure it's not going to be easy. So far the best I can do is to come up with finding duplicates on Item, Price, Description, etc. but that's only one record at a time and doesn't tell me if the two Plan#s match.

Any help or suggestions would be much appreciated.

Thanks!!!

View 3 Replies View Related

Summing Queries.

Jul 14, 2005

i'm going to start this by telling what i am working toward in the end as it is where the problem obviously stems from.

i am trying to create a report which will tell me how many times 'hcapp' is in a table. there are three different fields where 'hcapp' can be placed...i can easily create three different queries which return how many times 'hcapp' is mentioned in one field, but i have yet to figure out how to look through all three fields in one query...is it possible? if not, how can i have a report call all three of these queries and then sum the total?

View 4 Replies View Related

Summing Queries.

Aug 3, 2005

i've a question that hopefully has a simple answer.

i have a query that returns three different numbers (each in its own column)...anyway, how can i make it sum the number of these three numbers...the best case scenario would be if i could have a fourth column appear in the results of the query with the sum...

it would look something like this

num1 num2 num3 sum
1 2 3 6

View 1 Replies View Related

Summing Query.

Aug 18, 2005

hello there...ive a question...i have a summing query which searches for the word "processed" in a specific column of a table...currently if "processed" is not found within the column the query will not return anything...is there a way to have the query return a zero instead?

View 3 Replies View Related

Query On Summing

Feb 15, 2007

When i'm summing up values in a column like "Hours:[production]+[nonproduction]" how can i have access treat blanks as zeros? I tried
"Hours: IIf([nonproduction]="",0,[nonproduction])+IIf([production]="",0,[production])" and it just gave me a #value error

View 2 Replies View Related

Summing Many Yes/no Fields

Jan 9, 2008

Hello, I am a newbie access user, so this might be a stupid question, but here it is:

I have a lot of yes/no fields labeled "10/1", "10/3", "10/5", ... (dates)
They are to record attendance on particular days.
I want to make a query that gives me the sum of a student's attendance and I have no idea to go about that. Any help is much appreciated.

Thanks!!

View 1 Replies View Related

Sum Function Not Summing?

Mar 17, 2005

Can't believe I'm posting this :o Have tried every permutation I can find, including the previous requestes from other members, but it still won't work.
I have a subform on whose footer I've placed a text box to sum a valu, [SubTotal]. On the main form I've set the control source of a text box to the text box on the subform, and it just won't work :mad: Can someone please have a look at this and put me out of my misery?

Thanks, Lol :D

View 13 Replies View Related

Summing #s In A Query

Sep 8, 2004

Hello,

I'm trying to sum numbers in a query. The table that Im summing from is set up as follows. The 1st column is just an autonumber. The 2nd column is an individuals. The third column is a date. The fourth column is a transaction (Buy or Sell). The fifth column is an amount (in $). and the 6th column is an Account (RRSP or RESP).

I would like to sum all the buys for each individual for each account. However I'm finding this difficult to do. Here is what i have so far. It sums all the 'buys' for the entire table.

SELECT Transactions.[Customer ID], DSum("Amount","Transactions","Transactions.Transaction=1") AS Expr1, Accounts.[Account Type ID]
FROM Transactions INNER JOIN Accounts ON Transactions.[Account ID] = Accounts.[Account ID];

Thanks very much,

C

View 7 Replies View Related

Summing One Field Value To Another

Aug 6, 2012

I have 2 field in a table - CourseMarks and ExamMarks. I am making a query to sum these two values. My code entered through the expression builder is Total: [CourseMarks]+[ExamMarks].

When the query is run there are no results if both fields have a score, but If there is a score in the CourseMarks field and none in the ExamMarks field the CourseMark is returned.All the field value data types are interger.

View 6 Replies View Related

Summing Fields In A Record

Aug 23, 2005

Hi,

Not sure if this is possible (sounds simple hopefully) but I was wondering if there was a way to sum certain fields in a record on a continuous form.

E.g. Field1 and Field2 in record 1.

Is it something simple like summing columns, i.e. Sum(Field1)?

Any help would be much appreciated.

View 1 Replies View Related

Summing A Calculated Field

Jan 17, 2005

Hi,

I want to sum a calculated field on one of my forms. The field is calculated by multiplying the cost of a good by its quantity. So far I have been unable to sum it. Does anyone know how I can do this?

Here is a link to what the field is related to just so you people know what I am talking about: Project (http://www.access-programmers.co.uk/forums/showthread.php?t=78815&page=1) ...basically I have fixed all the problems mention in that thread. All that remains is this field. I will attach my project in case that helps. (the calculated field is in the Treatment Form) Thanks in advance :)

View 14 Replies View Related

Summing Up 3 Fields In A Record

Nov 12, 2007

Hi,
I am trying to figure out the best way to design a table. The table is going to contain data concerning checks that have been given to a church. Each check could be broken down into 3 different categories; Tithes, Offering, Other. In other words one check for $100 dollars might be Tithes $40.00, Offering $30.00, Other $30.00. I need to be able to enter these three amounts into the record and then have them totaled in another field.

Is it best to do this all in one record or should I have two tables? If I have two tables how do I get one form to enter the break down into one table and the total in another table. Fyi, if I do this in one record I don't want them to have to enter in the total. I want the total that is entered to be calculated by the three previous fields.

Thanks for any help you can be on this.

View 14 Replies View Related

Summing Totals In A Query

Sep 22, 2005

SELECT Commissions.TransactionID, Commissions.OriginatorID, Commissions.AmountPaid, Commissions.DatePaid
FROM Commissions
WHERE ((Commissions.DatePaid)> DateAdd("d", -32, Date()));

I want to add up commissions paid in a month using a simple query and im not sure how to proceed from here. This example will pull records for the last 32 days, but now how do I do the sum commissions.amountpaid to work?

Thanks for any help.

Scott

View 5 Replies View Related

Summing Other Fields Per Record

Jun 28, 2006

Is there a way to use a query to sum totals of several fields per record? In the db I have designed, I have 5 seperate fields for estimates from different departments. There is also a field for Total estimates. What I would like to do is have the Total Estimates field autocalculate the total sum of the other 5 estimate fields. Is this possible to do through a query? If so how? If not - is it possible at all?

Thanks!

View 1 Replies View Related

Summing Records Where Field Is Between

Jul 31, 2006

I am trying to create a sum of a field called ec2mo where mopp is between 0 and 2 and then another sum when mopp is between 2 and 4, etc... I've tried a number of different things, but it doesn't seem to work - instead i get a single value for each field (i'm assuming because there are different values for mopp and many other fields)... I've attached the db with just that table.
Thanks very much for your help!
P.S. I'm not really at all good with using SQL so anything that can be done in a regular query would be most helpful!

View 3 Replies View Related

Summing Values By Considering The Yes/No Checkboxes.

Aug 28, 2006

Hi,

i have created a table that would calculate the total payments that are being made by a certain contractor. I am assuming that the contractor pays the money in three installments.

In a table I have created three fields which are all checkboxes that would state whether a payment has been made or not, for example, checkbox1 would state whether the first payment has been made. And I also have three other fields that states the amount to be paid on each installment

Now, i want to calculate the total amount that have been payed. For example, lets say that the first installment has been made (i.e the checkbox is checked), then the first payment should be added. And if the second payment has been made it should be added as well, thus finally giving the total amount that has been made.

I know how the logic should look like, but i just don't know the syntax that i should use in the query.

Thanks.

View 1 Replies View Related

Summing Two Fields In A Query

Jul 17, 2007

I have 2 fields, Accounts, Accounts CMO. I need those two fields to show in the same table in a new field called Total Accounts. I am summing them, but getting irregular results, some are right, and some are 4 times more than they should be? How would you go about doing this, maybe I am missing something.

View 1 Replies View Related

Summing A Subform Item

Apr 14, 2005

I'm having trouble with a text box, which is trying to sum some date in a subform. All I get is #Error, yet I'm sure I'm referencing the item in the subform OK. I've attached the database as it's self explanatory (I stuck a label on it).

The form I'm having trouble with is frmPurchaseOrdersDataEntry and you'll see what I'm getting at from there.

Any help most appreciated.

Ste

View 2 Replies View Related

Summing Column In Query

May 2, 2005

I have a query and one of the fields is numbers. When I run the query I would like for that column to total the numbers. How can I do this and the have the total appear in the Query?

View 1 Replies View Related

Continuos Form And Summing.

Mar 20, 2006

Hi All,

I have to admit that I have been staring at this this problem for some time now and can't seem to solve it. Hopefully someone from this form will be able to help...

The attached jpeg of my continuos form has the "traditional" access #Name? error in it. The text box's contain the formula to sum each column they are under i.e: =sum([txtamount]) , =sum([txtFinalForecastCost]),
=sum([txtCostToGo]). They are located on the form footer section. If I delete the last text box the other two text box's sum ok, but all three generate the #Name? error. Any ideas on how to get around this so all three sum?

This continuos form is a sub form of the main form and the last column is a calculation of: Forecast - amount = CostToGo

Access 97

Thank you.

View 3 Replies View Related

Summing One Field For Default Value Of Another

Nov 23, 2006

I have two Numeric fields in my Table, MCRefill and MCTot.
Actually MCtot is the sum of all MCRefill for a given Cust_ID

I have the following expression in the Default value of MCtot in my form showing both the fields

DSum("[MCRef]","Miracle_Cloth_Main","[Cust_ID]='" & [Cust_ID] & "'")

Somehow it doesn't up in the record when you load the Last record for a Cust_ID

Can someone please help ?

View 2 Replies View Related

Hi! I Need Help With Summing Fields And Expressions

Dec 18, 2006

Hi! I'm trying to create a query using option groups, i have two options the first one is STOCK and the other is PD.
If i select stock the the query i want to create to introduce it on a form is:
I have 5 fields
-denominación
-reserva
-almacen
-cantidad
-stmax
If i select stock
then the query is
If (reserva +almacen)<cantidad then on a sub form have to appear the table with all the rows where (reserva +almacen)<cantidad.
but if i select PD only have to select on stmax the rows where value=PD
PLEASE i need help with this....

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved