Hi,
I created a field of type number and formatted to display percentages; however, it seems to add two zeros at the end of every percentage I enter. e.g. if I type 9%, it will show 900%.
Am i doing anything wrong here?
Any help will be very much appreciated.
B
I use Access 2003. I've set the Data Type on a field name to = Percentage
I've tried to use all - Field size types
I want to enter in 50 in the table and have the output be 50% currently it goes to 5000%
Is there anything i have to add in the Validation rule to make it show the exact value?
On a table I have a field labeled "Interest", and it is for what you would expect.
I have the data type set to Number, and the format set to Percent. For some reason I cannot change this field, it keeps resetting the value back to 0.00% even though I type something else in.
Access 2007
I am trying to make a query that give me an output of an aggregate percentage column, or running sum of percentage. Please see my example:
Month Sales in % Running sum percentage
Jan 5.03 % 5.03 %
Feb 2.17 % 7.20 %
Mars 1.28 % 8.48 %
I have the column Month and Sales in %, What do I have to do to get an output like the example over?
I have a text file delimited and uploaded the information to a new Access Table. One field "MarketValue" has a number followed with a percentage (i.e. 100%, 54%, etc..), however it converts as a text column.
How can I convert the column to a TRUE percentage field representing the value originally imported.
Hi all,
I would very much appreciate help with this one. So thanks in advance if anyone can help.
I have a table which has a Text Field (it has to be, I'm afraid). The data is listed as follows:
5.6%
12.23%
2.45%
etc.
I need to use these values to multiply other figures in queries. I have tried FORMAT and various other ways in the query to convert the data, but to no avail. All I get as a result is an ERROR. Anyone got any ideas?
Ginny
I have a database which tracks the performance of my team and how long it took them to send something out to the customer. We have a target of 5 minutes.
So I quite a few queries to drill down this information. I have a summary query that takes that information and tells me the total amount of things sent, the amount of things sent in time and the amount of things sent late.
My team have to get at least 95% out on time. So how would I go about adding this bit into the query. The calculation is:
The amount sent on time / the total amount * 100
But is there anyway to add this into a 4th column displayed next to these figures?
Looking around a few people have talked about SQL but I no nothing about this and it seems quite daunting, is there a way to do this as a calculated field?
I am trying to work out the expression that will first count the number of 'Yes' returns in a series of yes/no boxes and then display as a percentage.
To explain...The yes/no boxes represent attendance over a 20 lesson course. I have added a count for each lesson for student attendance..(grouping them in the footer) but I would like to add the number of attendance for each student.
I am trying to add a percentage sign (%) after a number I get from a table, thus the number 1,5 should display 1,5% and NOT 150%.
I am using the Format Property of the text field.
I tried #,##% which converted the value to a percentage (1,5 became 150%) Then I tried #,##"%" and #,##\% Access ignored both and changed the value in the property field to #,##% Using the Format function is not an option because it is a bound field which should be editable.
I'm a Access novice trying to set up a table to record the answers to simple yes/no questions. I've got all the questions set up and yes/no fields set for their responses, but I now want to add a field that calculates the percentage of yes responses on that particular report and record that too. I'm trying to use the 'calculated' data type, but then I can't work out what to type as the expression.
View 2 Replies View RelatedWe're trying to create a database to read quotes from a system based on changes made to components.
We have the database set up to store the quotes happily. We're pleased with the input forms and data capture however we are struggling with a query to get useful data from the database.
I have a main quote data table listing all the required fields such as costs and supplier data for the quotes, a table storing components that may be changed as part of a quote and a table listing alterations that could be made to these components. Each quote could have a number of changes made to a number of components. All these changes are stored in a changes made table which lists the quoteID, ComponentID being changed and The AlterationID of the alteration being made.
I want to be able to input a varied amount of changes via a form and be shown a list of all quotes where at least one change matches. I've managed to get this far using a lot of OR statements however the complexity is introduced as we need to sort these by an extra column produced by the query displaying the percentage the changes made in the quote match the search input.
If a quote appears matches my changes and there are no other changes on the quote - (100%)
If a quote matches all changes I have input but I input 5 changes and the quote has 6 - (5/6 - 83%)
If I input 1 change and a quote matches but has 8 changes on the quote - (1/8 12.5%)
The calculated field converts all percentage marks perfectly fine with grades except 100 which returns to a stupid "E" . I've been trying all sorts and now give up.
Code:
Grade:IIf([Percentage]<20,"U",IIf([Percentage]<30,"G",IIf([Percentage]<40,"F",IIf([Percentage]<"50","E",IIf([Percentage]<60,"D",IIf([Percentage]<70,"C",IIf([Percentage]<80,"B",IIf([Percentage]<90,"A",IIf([Percentage]<100,"A+")))))))))
I have two collums, currentowed and currentpaid. i want to add another field to my report showing the percent of currentpaid to currentowed but I can't seem to be able to make it work. I tried:
=sum([currentpaid]/[currentowed]) and it doesn't work.
From a table I want a text field which has a path to a file to be copied automatically into a another field of the same table with a hyperlink text type...
View 5 Replies View RelatedI have a field defined with a Yes/No type. When it appears on the form instead of showing up with a Box with a checkmark, it shows up as -1 or 0. Any thoughts as to what could be the problem ?
Thanks.
hello people, i wanted to add a string at the end of a long column of Currency. Is there any to to change only the last field to a string or do i have to change the whole column just for the last field?
View 2 Replies View RelatedI have a query to go through a table and pick up the amount of money earnt during a period then I use that field to calculate commission, but the commission field just shows up as numbers and not as currency as the set field in the table does.
Is there anyway in SQL to say what sort of data type a field should be...
Example of sql string
SELECT Sum([Work].[Earnings]) AS [Period Earnings], [Period Earnings]*(17.5/100) AS [Commisssion] FROM Policy
Hi Everybody,
I have a database in mind but I will need a new field-type that would contain an image file. I don't care if the image format is jpg, bmp, or gif or whatever.
Can I store any image inside an access database, and if so how do I do this? Hopefully, I can have an inventory database that would also contain an image of each record in the database. ( I hope to store the actual image in the field, rather than "file-path" pointing to a directory full of actual image files )
Regards,
-Paul-
I have been researching changing the field type of a table to Hyperlink and have been unsuccessful.
Everytime I add a field to a specific table the hyperlinks get busted. What I am doing programmiticaly is:
1. Deleteing the field
2. Re-creating the Field (text)
3. Concantonating two fields into the new field
4. Create a second field (hyperlink)
5. Copy those recrods into the hyperlink field
6. Delete the first
7. Rename the hyerlink to the original feild name
I get this to work but the hyperlinks are still broken.
Programmatically:
If I Create the new field
Concantonate two fields into it
Then Manually Change the field name from Text to Hyperlink
everything works great.
QUESITONS:
WHAT CODE is being run whern you go into the properties of the table and change the field type from Text to Hyperlink?
Can I use that code for this purpose?
Hi,
I have searched on this and it says: it doesn't matter as long as it's of type text. It matter if it's long integer..etc. I am not quite sure.
I wonder if default size '50 of fields' of type text occupies that size in memory even though the data in the field is not 50 chars.
Regards,
B
Have an odd problem that eludes me at the moment I have table with a text field for surnames and if I type the surname Ballance into the table it automatically reverts to Balance can see no logical explanation for this at the moment funnily it does exactly the same in excel
View 3 Replies View RelatedAccess 2002/2003. I have inherited an old Access 2000 database where one of the fields in the table had a Number data type with TEXT in it. I noticed the wrong data type and I change it to text. All appeared OK until I attached a combo box to this field. When clicking in or opening the combo box in any row in this table with the old text, I get an error message: "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits." This field has about 3,000 records in it, and it appears to be corrupted and a permanent numeric field, I have tried everything to fix it: Compact and Repair; Import, append, and update this field into another table/field and I cannot get rid of the error message. How do I get that Number field finally and completely converted into a TEXT field? Anyone got any ideas? Thank-You! :o
View 1 Replies View RelatedI have a field which is formatted as currency. When a button is clicked, it shows the value of the field. Because it is a currency field, if you enter "10", it is immedatly changed to "£10.00", although when i use txtAmount.Value, it gives me the "10" value. This is especally a problem if pennies are used - if someone enters "15.10", the .Value reterned is "15.1", which makes it seem like "15.01" has been entered. How can I get the currency-type value form the field?Thanks for any help.
View 4 Replies View Relatedhi,
I have atable with fields time in and time out (short time type), in aquery i did a diffrence between that to fields, so I can know to evry employee every day how many hours work.
but, my problem is how do summation to the work hours to the month (it's a short time type).
example, an employee work from 8:30 to 15:00 in the first day, second day work from 9:10 to 14:20 ....etc
at the end of the month i want to have report from query which give me sum. of hours the employee workes.
thanks to help me
suhad
i have a temporary table which is created by importing an excel file
some extra fields are then added to the table using sql vb code for example
strSQL = "ALTER TABLE [TBL_TmpSubmission] ADD COLUMN [EnergyUnit] TEXT;"
CurrentProject.Connection.Execute strSQL
these fields are later populated conditionally using an update exectuted again from vb code
If Me.cboProgram.Column(0) < 3 Then
strSQL = "UPDATE TBL_TmpSubmission SET EnergyUnit = 'GWh'"
Else
strSQL = "UPDATE TBL_TmpSubmission SET EnergyUnit = 'CarbonTonne'"
End If
CurrentProject.Connection.Execute strSQL
the problem is that this field now has a memo data type, this is a problem because i need to write a query which uses this field in a table join and access won't let you join on the memo type
anyone know why this might happen? for the time being i'm going to try and fudge this by using a further ddl statement to change the data type back to text but i'd rather know whats going on here
happy friday to all! I may just be missing something simple here but not sure what. I have a form with an option group of radio buttons, an unbound label, and an unbound text field.
If radio button A is selected, the the label and the text field become visible. no problem with this.
when they become visible, I want to be able to enter a string into the unbound text box, and use that data to populate a query from. I know how to do this also.
No the problem: when the textbox becomes visible I can't type into it?
Any thoughts?
Thanks
Kevin