Updating Total Cost In A Table

May 17, 2007

I have a table called: Invoice which has Invoice No (as the PK), Invoice Date, Total Cost.

I also have another table called Task: which has Task No (as the PK) , Task Type, No of hours, Charge Amount.

The user enters the Details of Task and Invoice in a Form. I have a field called Total Cost of my Form which should Calculate =([No of hours]*[ChargeRate]).

The problem I have is the total cost on the form is not being updated on the Invoice Table with The Total Cost.

Can anyone help please

View Replies

Auto Updating Total Order Cost After Quantity Is Changed

Oct 11, 2006

Ok so here is my problem:
I have a form that is realted to four differnt tables with the names: CUSTOMER, ORDER, PRODUCT AND ORDER LINE. With-in the table Order-Line there is a entity called, line_item_cost whcih is the total amount of the order with respect to Quanity_Ordered which comes from the ORDER LINE table and Price which comes from the PRODUCT table and Discount (%) which comes from the CUSTOMER table. When the users goes to change the Quantity_Ordered I need the form to automaticly update the line_item_cost which would calculate [Price]*[Quantity_Ordred]-[Price]*[Discount] . I tried to build a code in VBA to do this, Here is the Code:
Dim a, b, c, d
a = Me.[Quantity_Ordered]
b = Me.[Price]
c = Me.[Discount]
d = a * b - b* c
Me.[Line_Item_Cost] = d

VBA Complies the program but it does not show up in my form.
I think I might be updating it at the wrong point.
Any Suggestions.????

View 4 Replies View Related

Total Cost

Apr 3, 2007

Well at the moment i'm still in the design stages, but i made a database with test fields to see how it would work out best.

Basically i have to have a form with a drop down list for each type of computer componant and when selected the total price for all the items selected so far needs to show up at the bottom of the form.

Or when a button is pressed the price could be updated, that is fine too!

The way i was planning to do it was having an orders page, in which each field was a lookup to a difference table, one for each componant
Processor; ProcID, Proc name, Proc cost

Anyone have any ideas on the easiest way to load the total value for the items selected? Would be much appreciated! Thanks!

View 12 Replies View Related

Total Cost Help

Dec 8, 2004

I need to create a report that shows profit/loss totals for a vehicle that I have listed in a table named "Vehicle Table". I have four columns: Cost, Shipping, Promotional expense, Repair, that I need to total and then subtract from the sales price to show the profit. Then, divide the profit by different percentages to show what I owe each salesman. I need to keep the different columns seperate and be able to increase the dollar amounts in each column as a new invoice is received for each vehicle.
For example, I have a $25.00 wash job in the "Repair column" and then I have to install a new set of tires for $450.00. The total in the "Repair Column" should now be $475.00. I can not make it add to the current balance in each of the certain columns. Would someone be so kind and help?

Jeff

View 4 Replies View Related

Total Cost Displayed

Jan 28, 2008

Hi,

I have a order system which allows customers to place items on. When an item is selected and a quantity has been entered and add button is selected, this adds the item into a listbox with all the details.
Each item that is selected a quantity is selected, this would then work out a total price and this total would be displayd within the list box too.
i want to add all the totals up for that order and have it displayed within a text box.

for example:

product ID, Name, quantiy, item price, totalcost
P0001 Top 5 1.00 5.00
P0002 Top 4 2.00 8.00
P0003 Top 3 1.00 3.00

i then have a text box where i want to display the overall total for these items within. hope this helps. im really stuck on this one!!!

View 4 Replies View Related

Calculating Total Cost

Dec 7, 2004

I am currently making a database project for a school assignment.

I have based the project idea on a local hotel, which consits of a diffrent price dependant on the date booked.

So i have set up a table called "prices" which consits of the following fields:

PriceID
RoomID *
Price
Start Date
End Date

the RoomID is the foreign key, as it is linked (one-to-many) with my Room's table, which consists of the following fields:

RoomID *
Room Number
.. (unecessary fields for the problem)

The room ID is also linked to the bookings table (again one-to-many) with the bookings table consisting of:

BookingID
CustomerID
RoomID
Start Date
End Date
... (uneccessary fields)

what i am hoping to do is (i assume) make a query that will calculate the cost the customer has to pay. So it will look at the start and end date booked in the bookings table and comapre it to the dates in prices table, and find out the cost from this....

any help on going about this would be greatly appreciated, and i hope i have supplied sufficient information (i'll try attach a graphical image of the relationships if that is helpful?)

thanks

michael

View 2 Replies View Related

Queries :: How To Create Total Cost Field

Oct 27, 2014

I have a table called Price list, and in it I have two fields, one called Service and The other called cost. The services are listed and their matching prices are listed beside.

In another table called appointments, when making an appointment, I have linked the information so that I can choose from a dropdown from the price list table, under Service type.

I need to be able to create a receipt for the appointment. How can I do that in a query format?

View 1 Replies View Related

Forms :: Summing Up In Continuous Form - Total Sell And Cost Value

Sep 8, 2014

I'm adding to a DB which has been working well for a while.

I have a continuous form which has a query behind it. The query takes two values: (For example)

[LineCost] and [LineQTY]

Inside the query, we use the expression TLC: [LineCost] * [LineQTY]

I need to sum this so a Sale with several lines gives me the total sell and cost value.

If you look at the sfrmEditQuote - you'll see the exact same method - working. sfrmEditSale is direct copy of this form, with some changes here and there. But can I get past the dreaded #error? Nope.

I've tried renaming the fields and text boxes, checking the query, but I keep getting #error on the sfrmEditSale form footer.

I have attached the DBs in old and new format.

View 14 Replies View Related

Forms :: Updating Cost Without Changing Previous Records

Apr 11, 2014

I have this estimate database for a construction company. In this database I calculate how much will a project cost. It's pretty much complete the only problem that I have is trying to figure out how to update the cost of a trade without affecting older records

Example let's say we have a painter that makes $15/hr in project A,B,C,D,E we decide to give him a raise so project F would have a new amount for painter. The problem with that is that it will affect record A-E

I don't want that my department wants to go back and view a history of records. Also take a look at my database it's my first time creating one ...

View 7 Replies View Related

Total Newbie Question - Form Updating Not Table

Dec 1, 2004

Okay I've looked around but haven't found an answer to this, if there is one in the forum please forgive me. I've created a database to help track employee passwords for differnt system I placed and Audit Trail on the form (the example from Microsoft) however it updates only the form and not the table and I need it to do both. Please Help!

Thanks

Rand

View 14 Replies View Related

Calculating Line-Item Cost In Table

Oct 11, 2006

I 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

View 1 Replies View Related

Forms :: Updating Fields Via Code Not Updating Table

Dec 16, 2014

I have a form that has combo boxes and text fields (as well as sub forms). There is also a button linked to some code that says'

Private Sub cmdQuote_Click()
'Creates quote date and prints quote
Me.QuoteDate = Now()
Me.cbAgentID.Requery
DoCmd.OpenReport "Quote", acViewPreview, , "BookingID = " & Me.BookingID
End Sub

When the button is pressed the QuoteDate field (it is bound) should be be populated, but unfortunately it is not. I have played with refresh and requery but cannot derive a solution.

View 1 Replies View Related

Updating A Form Based On A Query Using The "total" Feature

Aug 24, 2004

I have set up an ACCESS database of journal articles. Each article has one or more authors. I have created a form listing the article title, the name of the journal etc. Included is a subform listing each of the authors. The authors are listed in the order that their names appear in the article. I wrote a query to sort the articles alphabetically according the name of the first author (in the subform). The main form is based on this query so that all the articles are sorted according to the name of the first author. However, the query uses the �First� feature in the �Total� row on the query. The use of this feature precludes me from updating information in the form that is based on the query. Is there a way around this problem and if so what is it?

View 1 Replies View Related

Tracking Share Of Cost

Nov 8, 2006

Hello fellow developers.

I need a query to help me track share of cost for clients. Anyone have any ideas? This is what I am working with. sorry it didn't paste very well. My problem is that my query keeps subtracking the share of cost and I want it to stop subtracking the share of cost once the share of cost has been met. HOpe that makes sense. Thanks in advance for your help in this matter. Angelflower.

BeginDOSEndDOSInvoiceIDProcessedTotalDaysRateTotalAmountMCostShareAmountPayable
10/1/200610/24/20065Resid10-06Yes24$47.00$1,128.00280.16$847.84
10/1/200610/24/20065Resid10-06Yes24$64.70$1,552.80280.16$1,272.64
10/25/200610/25/20065Resid10-06Yes1$45.29$45.29280.16($234.87)
10/26/200610/31/20065Resid10-06Yes6$47.00$282.00280.16$1.84
10/26/200610/31/20065Resid10-06Yes6$64.70$388.20280.16$108.04

View 1 Replies View Related

Getting The Right Cost For Purchased Itens

Sep 25, 2007

hello guys,

hope you can help cause this is turning me crazy.
it's an inventory issue. i have two tables:

1) StockIN: ProductID, PurchaseDate, PricePurchased
2) StockOUT: ProductID, OrderedDate, QtyOrdered

Throught 01 year, I can make 10 purchases of pens with different prices.

I need to run a query of an individual department's consumption of pens in the month of June for example. I can get the right qty, no problem. But for $$$ purposes, I needed the query to return the most recent PricePurchased as compared to the OrderedDate.

Any ideas??

Thanks in advance!
Tiago.

View 1 Replies View Related

[Tables] Deduct VAT Off Cost?

Aug 3, 2007

Hi, I was wondering if there was an easy way to deduct VAT from ALL my records as I entered them with VAT, and now my boss is saying he wants them without VAT.

Is there an easy way to do this!? As there are thousands of records that I need to calculate the cost without VAT!!

Thanks.

View 2 Replies View Related

Queries :: Self-Referencing Running Total Used To Calculate Next Total In A Query

Jul 23, 2015

I am trying to create a query that has a self referencing running total based on the values (point totals) of itself (running total of values in the running total column that have already been calculated for all previous records) plus the total of new points being added in the current record, less the total of points being removed in the current record. This running total can never go below 0, if it does, the running total should restart at zero and add in only new points and begin the process again with the next records

I am able to do this in Excel in less than two seconds so I know there has to be a way to port this into a query. I've attached an excel example of what I am exactly trying to do

If it takes multiple queries to complete the required output I am ok with it. In my previous outtakes I have had up to 8 queries but just couldn't seem to do it..

View 9 Replies View Related

Total Daily Sales Queries By Model/Total

Mar 8, 2008

Hi,

1) I am pretty newbie to this access programming, do forgive me if my questions sounds stupid.

2) Basically I create an application in access capturing or production information for my company. now the top management suddenly wanted whats their main concern:- Total Daily/Monthly, Quarterly, Annual Sales (By Model If possible)

3) I start with daily (Lets don't be too overly ambitious).

4) I try to let user select dates from my calender control and reflect daily sales (in Total & By Model break down) insert into my form.

5) Understand someone told me from my previous post in Calender control I can achieve it either through forms or queries, which is a better way. (in terms of flexibility to change for program maintenance/ scalibility) wise ?

PS: Please forgive my ignorance :o:(

Thanks (In advance) & God Bless.

View 2 Replies View Related

Assign A Cost/price Value Toodrop Down Box

Jan 17, 2008

Hi all,

Might be in the wrong place but didnt know it it needed to be in query, form or vb sorry admin.

I need help, what i need is a way of assigning a price too a drop down menu.

Basically its a Form with a number of drop down menus where you can select different varibles colour, finish for a certain product, but theres no method to generate a total cost of selecting different variables.

Do you know of a soloution becuase ive exhausted my capacity!!

Thanks

View 5 Replies View Related

Total Of An Invoice To A Table

Dec 18, 2006

I would like to create a table which stores the of all an invoice. at the press of a button. I want to use this to see how much I am Owed

View 4 Replies View Related

Total Record Sum In Each Table

Oct 10, 2014

I've got a DB with a dozen tables and i was trying to find a way to put number of records contained in the DB, into the intro form. I mean, i wanted it to show the sum of the number of records in each table....i was trying with some query, but maybe is more functional VBA?

View 2 Replies View Related

Queries :: Updating Child Table List View On Change Of Main Table Row

Apr 19, 2013

Here's a query that the bottom listview in the attached form i.e. a listview representing a table of calls(many) to fims (1 top listview)

Code:
SELECT calls.id, calls.firm_id, calls.called, calls.said, calls.spoke_to, calls.next
FROM calls
WHERE (((calls.firm_id)=[firms].[id]))
ORDER BY calls.called DESC , calls.next DESC;

When I run the thing...I get a dialog asking me for firm id.

I want to change this so when I move up and down the firms LV (top)... the bottom LV updates taking firm id from the top LV with focus.

Access 2003.

View 2 Replies View Related

Queries :: Update Query (table To Table) Not Updating All Records

Nov 26, 2013

I'm using an UPDATE query to update records in one table (tblMain) from another table (tblTemp)

Here is my SQL :

Quote:

UPDATE [tblMain]
INNER JOIN [tblTemp] ON [tblMain].[MainField1] = [tblTemp].[TempField1]
SET [tblMain].[MainField2] = [tblTemp].[TempField2];

I only want to update the records in tblMain which have a corresponding record in tblTemp (linked by MainField1 / TempField1)

If any record doesn't appear in tblTemp, I want tblMain to retain the existing value for that record.

However, it appears that in such situations, the record in tblMain has it's MainField2 value set to null / ZLS.

I've tried using LEFT JOIN and RIGHT JOIN and also tried WHERE clauses but the result is the same every time.

View 3 Replies View Related

Forms :: Update Table That Is Recordsource For Combo Box That Is Updating That Table

Mar 29, 2013

I have a combo box (cboManifestNumber) that is based on the following table:

tblManifestData
ManifestDataIDPK (autonumber PK)
ManifestNumber
RemovedDate
ManifestComments
TsdfIDFK (FK frm tblTSDF)

This table is related to:

tblTSDF
TsdfIDPK (autonumber PK)

I need to be able to update tblManifestData with a new manifest number and manifest comments, along with assigning it a TSDF. how to be able to enter a new manifest number and the associated data without having it create two lines in tblManifestData. I thought that I could enter a new manifest number, then requery the table and form so it shows the complete list of manifest numbers (including the recently entered one) while staying on the newest entry.

View 2 Replies View Related

Calculating Line-Item Cost In Form

Oct 11, 2006

View 1 Replies View Related

Formula Problem: Different Year = Different Overhead Cost

Feb 22, 2005

Hi all. I have created a db for tracking different types of request (corrective action, preventive action, rework, scrap, etc). My problem is that the hourly overhead cost is different each year. (I use this cost to figure out actual cost of rework and scrap actions.) I know this is a simple solution but it is eluding me - I need to have this cost change each year but not affect the previous year's figures. Right now my formula is basic:

ReworkCost =[ReworkTotalTime]*69 ($69 is the 2005 overhead cost - this is the first year of use for the db)

I was toying around with using a table for cost alone and then using an If statement to pull the cost based on the year. Does anyone have a different idea on how to do this?

Thanks

Camille

View 3 Replies View Related