Need To Calculate Quantity With Price In Access
Mar 25, 2013I need to calculate qty with price in a form.
View Replies
ADVERTISEMENT
Calculating Quantity * Price In Table PLEASE HELP
Oct 11, 2006I am having trouble calculating a field in a table and on a form.
I have the following Tables
CUSTOMER: Customer No, Name, Address, City, State, Zip, Discount, Phone, Fax, Contact Person.
ORDER: Customer No, Order No, Order-Date, Delivery-Date.
ORDER LINE: Order No, Product No, Quantity Ordered,
line-item-cost
PRODUCT: Product No, Description, Price, Product Image.
I need to calculate the line-item cost and need it to update every time the user enters a new Quantity ordered on the ORDER LINE form.
I know its (Quantity Ordered*Price)-(Price*Discount) and I did this is a query and it worked but I need it to update in the form and update in the table not the query. I have tried everything (Macros, Queries, and Formulas) and I just can not get it to work.
Does anyone know how to do this?
Thanks
Calculating Quantity * Price In Table PLEASE HELP Wont Show Up
Oct 11, 2006When I use the code given to me the program complies but it does not show the new total price in the for box
dim a, b, c
a = me.[your quantity textbox]
b = me.[your price textbox]
c = a*b
me.[your total textbox] = c
This is the code I used and my total box is called (line_item_cost)
is there anything that I am doing wrong?
Queries :: Calculate Stock Quantity With Query
Jan 21, 2014I have a problem with calculating the total qty of two fields.
Code:
QtyMapics: Nz([MapicsQty];0)
QtySubComp: Nz([SubComponentQty];0)
TotalQty: [QtyMapics]+[QtySubComp]
When I calculate the values of the fields it pastes the values after each other.For example: if you have the values 1 and 2 (which should become 3) then the result is a value of 12.I've tried changing the function to SUM() but that didn't work.The reason I am using NZ() is due to the fact that some values have a NULL value in one or both of the fields and if NZ is not included it will not calculate anything.
Queries :: How To Calculate Current Stock (Actual Quantity)
Oct 18, 2014I have a query (Inventory Transactions Extended) in which i am trying to caculate current stock.
I have a form (Inventory Transactions Form) where i either add or remove Inventory Items.
I have used this statement to create a new field (Actual Quantity) to calculate current stock based on stock been added and removed:
Code:
Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition";[Inventory Transactions]![Quantity];-([Inventory Transactions]![Quantity]))
for some reason it does not work. It is not calculating current stock. If i remove stock it shows a negative amount based on the amount i removed, and when i add stock it shows a positive amount based on what i added
I have attached a sample.
[ATTACH][/ATTACH]
Sample.accdb
Forms :: DSum - Calculate Purchase Quantity With Criteria Of Product And Quantities Before Sale Date
Nov 2, 2014I have a form with subform . I want to calculate purchase quantity with criteria of product and quanties before sale date. If i use with specified date it gives correct result.but if i use field address it ignores date criteria
Nz (dsum ("pqty","purchasequery","product=" & [sales.product] & "and clerancedate<=#31/07/2014#"),0)
Nz (dsum ("pqty","purchasequery","product=" & [sales.product] & "and clerancedate<=#" & [forms!salesm!sdate] & "#"),0)
But it is not working
Sdate is date and it is on main form
Forms :: Purchase Order Form - Calculate Auto Total Price
May 20, 2014I need to make an order purchase form like i have customer table and product table, i want to make a form which creates order for a specific customer and I can add as much items as i want and than calculate auto the total price, and an option to make a report for it.
View 5 Replies View RelatedForms :: Split Record Quantity To Multiple Records Based On Quantity Per Package
Jun 21, 2013I have a form for inserting invoices, and on the subform records I have a command button to print the labels, the label would contain the quantity of the product, so, if the quantity is ex. 11000 and package contains 2000 only.
so I have to print 5 labels with quantity 2000 and one label with 1000 qty
what I need to do, is when I click the label cmd button to insert the 6 records required to print the labels to temp table
Tables :: DLookup Between Two Tables - Calculate Product Price?
Jul 30, 2014I'm trying to do a lookup between two tables, whereas table A includes the product ID and table B includes the price. Is it possible to create a field in table A with a DLookup function on the product ID to get the product price from table B?
Whenever I try to type in the DLookup function, it does not calculate.
Queries :: Item Without Price Or Duplicate Price
Jul 29, 2013I have a table called Books, in that table there is 4 columns ChapterName, Auther, ITEM, Price.
Each book has a item number, and each book has a few records with the same data, just the first column is different where its the ChapterName, each book has a price, but only once, meaning in the first record of each book it will be a price in the column price
Now I want a Query where i can get which book dont have a price at all, and which book has more than once a price, how can i do that?
General :: MS Access Code To Update (add / Subtract) Value (quantity) On Table / Form
May 15, 2015I have a 'tblStock' with fields 'ProductID', 'InitialStock', 'Buy', 'Sell' and 'UpdatedStock'. I also have a form 'StockUpdate' add values and also add new records to 'tblStock' .
If I have value [100] for IntialStock quantity, Buy [0] and sell [10], UpdatedStock will be [90] (that's done and fine!).
The problem is, I would like to make the UpdatedStock value [90] to be the NEW InitialStock, so that any BUY or SELL will keep updating the UpdatedStock and making it the NEW InitialStock for the next transactions and so on....
Price Calculation In Access Like Excel
Dec 11, 2007Hi all,
Help me solved my problem with price calculation in Access.
Please kindly view below excel file.
http://www.hwakeat.com/templates/AT05HKGP01/pdf/Products.xls
I like to do formula price calculation in Access like my sample excel file. How many table should I create & How to build query? Whenever exchange rate change or MarkUp price rate change, I only want to type once & it will affect the whole access.
I have tried so many ways in Access but it doesn’t work like my sample excel file.
Please Help me!!
Need Help To Calculate A Running GPA In Access!
Apr 25, 2006Hello, I have volunteered to do a database for the school of nursing to use at a small Christian University using Microsoft Access 2003. I have Students, and each of these students is going to take each of these 12 nursing courses. Each nursing course has a specific number of credit hours (2,3,6, etc.) and they are to receive a grade for each class (on a 4 point scale, so their grades are going to be a number 0 for F through 4 for an A). I need to have access calculate a running GPA which only takes into consideration the classes they have completed thus far. Any help would be appreciated. I can do it in excel by just leaving the row for untaken courses blank, then autosumming the credit hours column for total hours taken. I can use a formula for each row that just multiplies the grade (like 4.0) by the credit hours (like 3) and get a total grade points of 12 for that course. Then I can add those numbers up(autosum the total grade points column) and devide by the calculated autosum number I would call total hours. I hope it is clear what I am trying to do and why I don't know how to do it in Access. ***************Extra Info*********
I have a student table and each student has a unique studentID, I have a second table called Nursing grades which I have a Student ID field, and 2 fields for each class a grade recieved and a credit hours field (ex. I have PharmacologyGR and PharmacologyCH, NursingResearchGR and NursingResearchCH). If I need to redesign how I have my tables I can do that, I have a unique Course ID for each course I could put in if needed. Basically, I'll do whatever it takes to get this to work.
Thank you so much for even reading this far, and any help would be appreciated more than you know.
Minimum Quantity
Aug 9, 2007hi
i try to build an access form .
i have "big" table that fill in the name of the product , the quantity , and a minimum quantity.
the field : min quantity give us the quantity that is the minimum of the product.
i have a "minimum" table that has the list of the product and the minimum quantity.
i want to see the minimum quantity of a product , when i type the product (in the form if it possiable , if not - in a report)
eran
Calculate Percentage On Access Form
May 4, 2006Hi, Thanks in advance. I am trying to calculate percentage, it has to round to the nearest, and also if the percentage is greater than 100 then it has to write 100%.
formulae: c=(a/b)*100,
example: c=(8/3)*100 =266.66% but this is more than 100% so i need this as 100%
example2: c=(2/3)8100=66.66% but i need it to round as 67%
i've 3 controls on a form a,b,c. so c has to calculate by itself when they enter data on a and b.
thanks,
sam
Is It Possible To Use Access Calculate Freight Costs
Nov 24, 2007I need to audit the freight bills charged by freight company which has over 20,000 consignment per week. The basic charge is base on distance and weight, something like this:
SYD-MEL <1kg $6
SYD-MEL<3kg $6.7
SYD-MEL<5kg $7
SYD-MEL<10kg$10
SYD-MEL>=10kg $12, $4 per kg rate
SYD-PER<1kg $10
.....
Based on the freight rate, how can I use Access to calculate the freight charge for each of the consignment ? Is there anyway to build some query or something to retrieve the freight rate and calculate the freight cost of each consignment?
Thanks
Date & Quantity Query Help
Sep 28, 2005Hi all,
I need help with what I think is a relatively simple DB. I'm creating a DB with 2 tables:
1) Inventory Balance with the following fields:
*Month
*FiFo Date
*Article number
*Quantity
2) Transactions with the following fields:
*Month
*FiFo Date
*Article number
*Adjustments qty (positive or negative)
*Receipts qty
*Invoice Create qty
*Invoice Void qty (negative)
I've added the month so I can filter any given month.What I want is a query that will calculate my closing balance (in qty) following the FIFO method and I haven't got a clue how to start.
Can someone help?
Thanks,
Ingrid
Change Quantity To Rows
Feb 26, 2006Im integrating a Scanpal Batch barcode scanner into my application, and need a little help with my label printing facility.
at the moment the scanner imports a list of barcodes and quantitys this is merged with my product table and results in a table something like this:
barcode | Description | price | quantity
123456 | my stuff | 9.99 | 7
i need a query to move this to my label printing however my print queue works like this
barcode | Description | price
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
can a query do this?
Thanks
I Need A SUM Of Quantity Depending Also By Date!
Jul 28, 2006I am searching the net for a response to my problem but no result;
I have 1 BD access (Facture) in witch there is 2 tables (Entete_Facture and Detail_Facture) with a relation in Field (Numero_Fac).
It is very easy to use "INNER JOIN" to do a Query (Facture_with_date) fusionning the 2 tables, But I want to add to this query another column : " SUM(Qte_Article) GROUP BY Code_Article " as below:
Query Doubles Quantity
Mar 28, 2007I'm sure that this issue is simply. I've done it before, but for some reason I'm having problems today. :confused:
I have 4 tables in one database as follows:
1) Sort Table = Sort #
Sort Date
Qty Sorted
Qty Rejected
2) Sorter Table = Sort #
Sorter Clock #
3) Operator Table = Sort #
Operator Clock #
4) Defect Table = Sort #
Defect Type
Defect Qty
When I attempt to query these tables, my totals increase.
EX: I have 500 items sorted; 100 defects; 2 sorters; 2 operators and 100 defects of type 1 and 100 defects of type 2.
My query results are 1000 items sorted with operator 1 having 100 defects of type 1 and 100 defects of type 2 and operator 2 having 100 defects of type 1 and 100 defects of type 2.
My quantity of items is doubled because it took (2) operators to make the items. My defects are doubled because it took (2) operators to make the defects.
Please help.;)
Parts Quantity And Orders
Mar 1, 2006Hello All,
I am new to this forum :) and learning Access :confused: .
The Database
Tables:
Employees
Products
ExpectedQuantity
PartQTY
Parts
Most of the products are similar so they have the same parts for the majority. However they do not all have the same parts. So I created a parts table that contains all the parts needed for any product. Now each Product also can contain multiples of one part (such as wheels) where I would want to list the Product and the parts list and quantity needed of those individual parts for that product. Hence the PartQTY table.
Now what I want to be able to do, is go into a form where each record is one of the products. A subform (datasheet view) for that product that shows all the parts and the quantity of each part that make up the product. Such as 4
wheels, 5 screws, etc for Product A.
I would like there to be an ExpectedQauntity field in the main form which once you found the product you can enter in the number of that product expected. Then this Qauntity would be multiplied by the qauntity of each part required (in the datasheet subform a column with =[expectedQTY]*[PartQTY]) and list next to each part the number needed to order. So if for product A the expected quantity is 50 I would have to order 200 wheels and 250 screws for that product.
A report would Sum each part qauntity after the expectedqauntity has been entered for each product. So I could print a report that tells me how many of each part we need to order based on the expected qauntity of all the products.
I think I am complicating things and would like a fresh mind to assist me in which direction to go.
Thank You,
Adam
Calculate Working Time Between Dates In Access
Oct 26, 2006I have searched the forum for this answer but no luck. :(
I'm trying to calculate the amount of WORKING time between two dates in an Access database. At the moment i am just subtracting one date from another but this gives me all of the time in between including weekends and evenings.
I need this time to be calculated in hours.
In Excel i know there is a NETWORKINGDAYS function which does something similar but with days rather than hours.
At least if i could get the working days i could then convert it into hours.
Please help!
Queries :: Access Database To Calculate Income Tax
Jun 22, 2013Access database to calculate income tax?
I'd like to be able to input the amount I invoice each month into a table and it would calculate Vat and Income tax due.
I'm sure its been done many times before however I cant find any examples.
Queries :: Sum Field Then Minus Quantity
Jun 3, 2014I am trying to sum a qty field naming it 'TotalRecieve' and then minus a qty from that sum?
I've tried the following
Code : RemainingQty: Sum([tblReceiveDetail].[QTY])-[tblOrderDetail].[Qty]
but i get an error saying 'Your query does not include the specified expression as part of an aggregate function?
Queries :: Multiply Time By Quantity
Apr 27, 2015I have the time per item, and I would like to multiply that by the quantity, so I can tell the total time. But I cant find in access how to * data/time by a number.
View 3 Replies View RelatedGeneral :: Sum Quantity In Form From A Different Table
Apr 22, 2014I have a table called ( purchasing ) I also have a form called ( stock )
I purchase parts from stock and those quanities goes into the table ( purchasing )
Is it possible to create a text box in the form ( stock) that looks at all the table purchasing and sums up the qtyreqd for the part in stock ...
I have tried = sum([purchasing]![qtyreqd]) but just get an error ....