Is It Possible To Use Access Calculate Freight Costs
Nov 24, 2007
I 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
View Replies
ADVERTISEMENT
Aug 14, 2007
I have a variable cost that is a calculated field (as in the colum only exists in a query not as a colum in a table) that is variable hours * variable rate....the problem is ppl at my company sometimes dont know how the costs are goign to be broken down so they only put a Variable Cost....
and since they dont know the rate and hours my calculated field returns nothing...
how can i accomplish this, VBA might seem the way to go but i don't know how to use it for Access.....
so basically i need to calcualte the variable cost only if they enter something in var hours and var rate...other wise the var cost should just be what the users type ( so i i guess i have to make Var Costs a column in the table to give users the option of entering it)
View 3 Replies
View Related
Aug 9, 2007
I have a query that calculates Total Costs as (total fixed + total variable). total fixed is ( fixed hours * fixed rate) and total variable is (var hours * var rate) as expected....
But one of my records only has Var hours and a Var rate,therefore calculates total variable fine, but since this certain product doesnt have any fixed cost my TOTAL COSTS record for that product is left BLANK??
If there is no fixed cost than the total cost should just equal total variable....
When you enter a fixed cost and rate it works as expected though...any idead please i am on a deadline, im pretty sure VBA is the easiest way to go but i dont know how to go about it, this query is the heart of the whole Application, it is used primarily as the source for a few reports so this throws off my totals.
View 5 Replies
View Related
Dec 21, 2005
I have a table with products and their costs per unit of measure.
some products are costed by weight and others by piece.
table looks something like this:
product
pcs
weight
unit of measure (EA or KGS)
cost
Query should look like this:
product
pcs
weight
Total Cost
Is it possible to write an expression that, depending on the unit of measure uses the pcs or weight field to calculate the total cost ??????
View 5 Replies
View Related
Mar 26, 2006
I have set up a query for an invoice to work out the sum of the field etc, but another one of the criteria is to search between 2 dates, how can i have the dates set as variables which i already have managed but be able to make the sum of the prices just be set between these variable dates?
View 1 Replies
View Related
Aug 8, 2006
Hello,
I'm setting up a delivery cost and location form. What i need this form to do is say i select Guildford for delivery i need the delivery cost text box below to say £12.50 without manually looking up the costs for that area and if it was Farnham then £24.00. What is the easiest way of doing it?
Thanks
View 3 Replies
View Related
Apr 25, 2006
Hello, 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.
View 1 Replies
View Related
May 4, 2006
Hi, 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
View 1 Replies
View Related
Mar 25, 2013
I need to calculate qty with price in a form.
View 14 Replies
View Related
Oct 26, 2006
I 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!
View 7 Replies
View Related
Jun 22, 2013
Access 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.
View 1 Replies
View Related
Jul 26, 2006
I have a problem with Microsoft access 2003. I want to design a Check in/Check out Time Data base for my university final term project. In this data base I need to show the total of the working hours of each personnel in a month.( for instance: 124 hours and 55 minutes in one month). But adding up the hours, when the time variable reaches 24 then time automatically goes back to 01:00. As a result, the correct total hours cannot be calculated....
View 1 Replies
View Related
Aug 11, 2014
In the attached image I was trying to calculate number of working days(throughput) b/w item received_date and item_released date by using datadiff with "w" interval . but if I use "w" interval it brings value zero .but if I use "d" interval then it brings result with inclusive of Saturdays and Sundays.i don't need that.
How to calculate the number of working days exclusive of Saturdays and sundays.
View 1 Replies
View Related
Aug 1, 2013
Is there a way to calculate accrued interest or an amortization schedule in MS Access? I know it's easy in Excel but I have a need to do it in Access.
View 1 Replies
View Related
Dec 16, 2004
How would i go about getting the field 'GMargin' (Gross Margin) to be calculated from subtracting 'SellingP' from 'PurchaseP' (Selling and Purchase Prices)?
How do i do this? Help me please :)
View 5 Replies
View Related
Oct 6, 2005
I have a field which I enter a short time such as 3:13, 5:45, etc
Now i am creating a report which at the end of the report I would like to include an unbound text box, which displays the total amount of time for that field (pls note that the total will never exceeds 24 hours) What is the best formula to use in order to calculate this ?
Cheers
View 4 Replies
View Related
Jan 18, 2006
Hello,
I am trying to sum minutes from a database using an Access query, but the format in the database is hh:mm. I know the query to use in Oracle:
ROUND(SUM((substr(actual_time,1,(instr(actual_time ,':' )-1))) *60 + (substr(actual_time,(instr(actual_time,':' )+1),2)))
but not sure of the syntax to use in an Access expression.
Any ideas?:confused:
View 1 Replies
View Related
Aug 6, 2006
HI,
Excel is having difficulties calculating a workbook of mine. It complains about cirkular references, so I had to set the iterations manually.
The workbook holds about 5000 records and I´m using a cosinus function.
The thing is I don´t know what to do. Excel calculates the workbook, but it doesn´t do it right. What setting should I use with the iterations?
I´m thinking of running it in excel 97. Will that help?
I really need to be able to run this workbook. Does anyone have an idea?
Fuga.
View 6 Replies
View Related
Jul 10, 2007
Hello, I didn’t know how to explain this or where to post this but here we go! I have two databases and one of the PC's here at work can’t use some of the items in the database like on one of the databases there is some formulas in text boxes and that PC won’t calculate what’s needed in them and every PC in the plant will except for this one PC. Also the one PC won’t bring up the Allen Browne's Calendar. When you press the start or end button to bring up the calendar it never pops up but if I enter the start date and end dates and use it that way ect then it works. I have no clue why this is just happening to this one PC. Any ideas?
View 2 Replies
View Related
Jan 19, 2006
I want to calculate a data from anthony table, like (20 Jan 2005) + 365 days
will be 20 Jan 2006, how can i do it.
The Table setting is just like below:
Constituent (DataID,...);
Student (DataID, DOB,...);
School (DataID, 4YearsOld(As a Date Format),...)
Anyone can help me, Thank you.:)
View 3 Replies
View Related
May 12, 2007
i have a table with fields "[DATE OF BIRTH]", "age", "temp-age"
i have a query that calculate the age:
example; the query will get user to input the "temp-age" and upon "temp-age" is input and "ok" on the query, it will calculate a person's age and store the value inside table "age".
however, the calculated value for the age have some data problem. for example, when a person whose age is yy:mm 24:05 the age inside the table will be 1924:05. there will be a additional "19" at the age.
what cause the additional "19" problem?
---------------------------------------------------------------------
my query in design view is like this; (see attachment)
it uses " [temp-AGE]-[DATE OF BIRTH] " to calculate the age and store into table "age".
View 1 Replies
View Related
Nov 10, 2006
Hello,
I'm trying to calculate months not days between
EX: 1/1/06 to 6/30/06
I tried to use end date (-) begin date, but is only give me the difference in days. What expression do I use to get 6 months?
:confused:
View 2 Replies
View Related
Nov 19, 2006
Hi, i'm trying to calculate the amount of employee for each company giving me a total in the queries.. how do i go about this? I'm not an person who uses Access to solve this. I have amount 20 Companies stored and over 800's employee.. Here are the field in the table:EmployeeIDEmployeeNameNumberofEmployeeThanks! Hope this helps.
View 1 Replies
View Related
Jan 15, 2007
Hi
I am very new to databases, and think i am a bit over my head. I am doing a database for vacation rentals, and am trying to calculate commissions, basically i wanted to have a set of checkboxes, labeled 10%, 15%, 2.5% and $25, with any combination of these checkboxes being able to be checked.
i want the query to work like this:
If the 10% checkbox is checked i want the query to take the SubTotal for the reservation, and calculate 10% of that number. if the 2.5% checkbox is also checked, i want the query to calculate 2,5% of the reservation and add it to the commissions total (10% + 15%)
I think(hope) that i explained that clearly? Can this be done?
Thanks for your help!
Ben
View 2 Replies
View Related
Mar 16, 2007
What is the easiest way to calcuate a median value for a group of values?
View 4 Replies
View Related
Apr 19, 2007
I am attempting to calculate the Average & Median on a particular field in a query.
=Median("qry2007_KPI_AvgJan_A","ContractSignedToReceived")
query name is qry2007_KPI_AvgJan_A
field name is ContractSignedToReceived
I am getting #Name? error.
Any ideas why? Thanks for any help troubleshooting this.
View 1 Replies
View Related
