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
In a report, I need to calculate the percentage of clients that respond "Yes" to a question on a survey. I need to create a query that will return the count of the number of "Yes" responses, and the number of total responses.
For example, if 10 clients complete the survey, and seven respond "Yes", I need the 2 fields in the query to be 7 and 10. So far, I have only been able to do this using multiple queries.
Thank you.
Does anyone know how to add a column to an existing table that would calculate percentage?
Thank you very much in advance!!!
Hey,
I'm unsure of how to do this one, any help would be appreciated.
The database I'm working on has around 2000 records within the parent table. These reflect projects around the world.
the child table has records on how much these projects cost.
I would like to calculate the % of projects cost less than £50,000, then, the % of projects between £50,000-£100,000 and so on.
i'm not entirely sure how to do this, anyone have any ideas?
Thanks
How to calculate the percentage of kilometers per order compared to the total number of kilometers per carrier.
In the attached screenshot send queries where I need formula.
Mileage on the orders of the field called "Korkma" . The formula should look like: # [Korkm] / [total kilometers per carrier] #.
I do not know how to get the total mileage driven by the carrier (the carrier is in the query in the Field Name Plate) for the month.
For example:
date 1.1.2013.,Plate:Pribus Korkm= 37
date 2.1.2013.,Plate: Pribus,Korkm=56
date 10.1.2013.,Plate: Pribus, Korkm= 70
Formula: [37]/[163] = 0,23
[56]/[163]= 0,34
[70]/[163]= 0,43
I have an Access 2009 report that displays the sums at the bottom of some columns. Is there a way to calculate and display the percentage one sum is of another?
Column1 Column2
Total 12,000 9,800
Percentage 100 % 81.7 %
To calculate the percentage of the number of passengers in the total number of passengers per single order using query:
Code:
SELECT
Code:
A.Date, A.Plate, A.Pax, A.Agency, A.Code, IIf ([pax]> 0, Round ([Pax] / (SELECT Sum (Pax) FROM Sheet2 as B WHERE B.Date = A.Date and B.code = A.code), 2), 1) AS KOR
FROM Sheet2 AS A
ORDER BY A.Date;
Query works fine in all cases except one, and that is when the encounter a same order in one day
01/04/2013. D_1 0pax
01/04/2013. D_1 5pax
in this case the formula gives a coefficient of 1 to 0 passengers and coefficient of 1 to 5 passengers, should be given a score of 0 0 of passengers and 1 to 5 passengers
I have two fields CountOFAppeal Description and Amount Solicited.
I just want to get the percentage of response.
So this is what I used:
=[CountOfAppeal Description]/[Amount Solicited]*100
When I go into the properties to format it to % and add decimal places I get a crazy number
2520.46% When it should be 25.20%
When I change the format to general number the decimal point is in the right place 25.20.
I have this table
Year AvgOfValue
2005 109.061690295772
2009 106.801581389669
I have to calculate the percentage of change of the values. I have very basic knowledge. How can I make a query to calculate the percentage of change?
I have two numbers, i need to calculate how much percentage of one is the other. E.g
num_1 = 100
num_2 = 10
percent = 10%
Users enter a dollar amount (retainer) and my code should calculate the percent of the total proposal amount.
Actual Code
Private Sub cmdSubmit_Click()
Dim intProposalTotal As Double 'if i use interger i get "overflow" error
intProposalTotal = Nz(DLookup("ProposalTotal", "qryPropsalTotalForRetainer", "proposal_id=" & Me.proposal_id), 0)
[Code] .....
billing_retainer_percent is formatted to Percent with 0 decimals. In the actual table Type - Number, Format - Percent, Field Size - Single. What i get is 100% instead of 10%.
What I'm looking to do is calculate the success rate (%) of compliance rates with Quality Control paperwork. Essentially, each record has 12 "check box" fields representing the different QC sheets that are submitted each day.
QCflavourChange
QCfillerOperator
QCblowMoulding
QCtorqueTest
QCnetContents
QClabeller
QCpacker
QCpalletiser
RMpreform
RMclosure
RMlabel
RMcarton
I have been able to find the code for counting the success rate of a specific type of QC sheet across multiple days worth of testing, eg:
=Sum(IIf([RMpreform]=True,1,0))])
But I have been unable to determine how I can count the total of all the successful fields listed above, across a single record.
I'm very new to Access and I'm attempting to write an expression in a query that will calculate the % of the count of "Exchange" field (Exchange is a text field and is grouped and the count based on each unique name) where the total count is based on the filter where "Group" = 'FS' or 'S'.
The below seems to work, but there is a better way of going about this (especially if I have to add more filter criteria). I added a pic of the query I'm trying to build.
PercentofTotal: (Count([Exchange])/DCount(Count([Exchange]),"[Holdings]","[Asset Group] = 'FS' OR [Asset Group]='S'"))
I obtained data for earnings by industry for men and women over time (5 years). I developed crosstab query that showed the average earnings for men and women for the 5 years.
Now I want within this query to calculate the differential between men and womens average earnings and calculate a percentage within this crosstab query. I tried to use Expressionbuilder with little luck.
I am trying to count how many of the "same" and "differences", as well as calculate the percentages of the number of "same" over the total amount. To clarify, I work at a nursing home, and I need to calculate the number of people who were admitted to our facility and then to the hospital for the same diagnosis, and a different diagnosis. Then, out of the total number of people who were admitted to the hospital from our facility, I need to calculate how many of those people had the same diagnosis or a different diagnosis.
Also, I need to categorize these diagnosis by each type of diagnosis.
I need to be able to store percentages in an Access 97 table. I have set the data type to double and 4 decimal places, but when I enter .14, Access rounds to 0 and stores it as zeros.
What am I doing wrong?
This is a very minor problem. But it's one of those things that will bug me to no end. I have a discount field on a pop up form whose format is set to percentage. The field it is bound to is also set to percentage. When the user entered, for example, 50, the field would change to 5000%. So in the AfterUpdate I divide the value by 100. This works fine. The issue that's got me stumped is the appearance of the value. When the value is 50.00% and the text box receives focus, the appearance stays 50.00%. When the value is 10.00% the appearance changes to 0.1. I've entered various values and some change and some don't. Would anyone know why?
View 1 Replies View RelatedHello, 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.
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
I need to calculate qty with price in a form.
View 14 Replies View RelatedI 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!
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.
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 RelatedIn 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.
Hi,
I have a from with 3 fields on it where users can enter numbers of boxes attached to a booking.
Each field stands for a box of a certain type.
E.g.:
20's ==> 1
40's ==> 1
45's ==> 1
Now, I want to calculate a total based on 40 being 1, 20 being 0,5 and 45 being 1,125.
The total in this case would be:
2*20 = 0.5
1*40 = 1
1*45 = 1.125
Total: 2.625
Is this possible, and, if yes, how do I insert this calculation?
Don't know if this is clear enough, if someone has any questions on my goal here, please ask me to clarify...
Thx once more,
Lion85heart
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 RelatedI have a form (frm_Active) that reads from a query (qry_Active) based on a table (tbl_Data). The form/query/table has the following fields:
EVENT DATE
START_DATE
REVIEW_DATE
APPROVED_DATE
POST-REVIEW_DATE
When I add a new record, I would like for the default dates to be populated based on the EVENT_DATE. For example, if I enter 1/1/2006 for the EVENT_DATE, I want the
START_DATE = +7 days
REVIEW_DATE = +55 days
APPROVED_DATE = +60 days
POST-REVIEW_DATE +180 days
I tried to do this in the table as the "default value" and it would not accept it. I don't think I can do this in the query because the query is basically displaying the table and I want to be able to manually enter a different date if needed so it will be stored in the table. I tried this on the form in the "Default Value" field, but it is just blank when I enter a new record and enter the EVENT_DATE. However I am not sure I am entering the formula correct. Can someone tell me what is the best way of doing this and what the correct formula is?
Thanks,
Jim