How to get 1 value from report to another form in ms access

https://www.amazon.com/ask/questions/Tx2O8NFDQMEMQYI

You can use the *key as your subtotal key.
This calculator supports stacking calculations with subtotals. Here is an example of how to do it:
-STEP 1
Start with your first calculation sequence. In this example the first stack will be the sum 100+1500+252
-Enter the values and after each value, press the +=key to add.
-After the last value, press the += key and then press the *key to have your first subtotal.
-Without pressing the CAkey, start just after the last step your next calculation stack. In this example, it will be 2500+451+589
-Enter the values and add them as the first stack.
-After the last value, press the *key. Here you will have the second stack total (or the second subtotal value).
-Press the G*key to have the grand total value (the sum of all subtotal values).
The paper strip will show like this:
..0..
100.+
1,500.+
252.+
1,852; *
2,500. +
451.+
589.+
3,540. *
5,392.

https://www.google.com/search?q=SUBTOTAL+KEY+ON+CASIO+hr-17ORC

..

If you already have a field where you want the total to be if you right click on the field and go to properties and find out the name of the field and also the 2 or more other fields that you want to add or multiply together then you can make the total field equal to the formula ie

if you have 3 fields

Field one = value1
Field two = value2
Field total = total

in design mode you would right click on the total field and go to properties and in the properties there should be a field where you can enter a formula.

in there you would enter something along the lines of

=value1.value + value2.value

Then when you have it normal view ie you open it, it should always add the values together and put the sum of them into the total field.

If you want an example database post back and I will create one.

If Access is anything like Excel, you can put in one of the cells: =SUM(A1:A5) If I remember rightly. That will add all the values from A1 to A5 together and display it. Alternatively, you can do =SUM( and then select all the values you wish to add together with your mouse by dragging, or selecting individually by holding CTRL whilst individually selecting. Hope this helps, because I'm only going under the assumption that Access is similar to Excel. Either way, you will need to use a formula similar to the one I just showed you.

Hello,
The following code will dynamically calculate the some of the first two fields:



Enter first number:
Enter second number:
Their sum is:

Best Regards, Ben

The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Reports: Page Totals Each section of a report has a Format event, where you can alter properties such as Visible, Color, Size, etc in a manner similar to the Current in a form. (See Runtime Properties: Forms for details.) For example to force a page break when certain conditions are met, include a PageBreak control in the Detail Section and toggle its Visible property. In addition, the Print event can be used to perform tasks like adding the current record to a running total.
You have an Amount field, and want to display the Amount total for that page in the Page Footer. Totals are not normally available in the Page Footer, but the task requires just four lines of code!

1. In the PageHeader's Format event procedure, add:
   curTotal = 0 'Reset the sum to zero each new Page.
2. In the DetailSection's Print event, add:
   If PrintCount = 1 Then curTotal = curTotal + Me.Amount
3. Place an unbound control called PageTotal in the Page Footer. In the PageFooter's Format, add:
   Me.PageTotal = curTotal
4. In the Code Window under Declarations enter:
   Option Explicit 'Optional, but recommended for every module.
   Dim curTotal As Currency 'Variable to sum [Amount] over a Page.

That's it! Don't forget to rate 4 stars for this solution.

(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

This will depend upon the question/option made. Anyway, sum / count the number of option having same answer and take the percentage. You will surely see how to make the conclusion.

Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:
=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

Hi smiths, Try adding a Label to the report in Design View. In the Properties, select the control source for this field. Insert one for your vertical and horizontal calculations as needed. Hope this helps. Regards DeltaC