Decimal Place Restrictions

Sep 27, 2004

I am building a database from a detailed Excel file which has upwards of 22 decimal places. Access restricts the decimal usage to 15 characters. Even when selecting the 15 characters, Access rounds the entry. The only way it will work so far is as text, but it is a calculated field. Any suggestions?

View Replies


ADVERTISEMENT

Decimal Place

Jan 27, 2007

i have a statement like this:

rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100


how can i have two decimal place?

View 1 Replies View Related

Decimal Place Issue

Dec 6, 2004

Hey everyone - is there a way within Access to set the decimal places so that it holds a 0 after the decimal if you put it in that way, but also uses Auto for the # of decimal places? For example, I'm trying to create a DB in which one of the fields is to hold GPAs. It obviously looks silly to have it displayed as 4 if it's 4.0, but I would also prefer to not set the decimal places at 3 and have it displayed as 4.000. I can do this if I have to, but what would be most preferable would be to have it record the number exactly the way I put it in, whether it's 4.0 or 3.875 without cutting off anything (0's or multi-digit decimals) after the decimal. Is this possible, or do I have to customize the output in ASP?

Thanks!

View 2 Replies View Related

How To Move Decimal Place For Percentage

Jan 18, 2006

On a from I am creating I want to make it user friendly. They enter an amount for a percentage. I have the format set to percentage. If you type in 99 you get 9900% instead of 99%. Is there an easy way to correct this?

Thanks

View 4 Replies View Related

Forms :: Set Decimal Place Property Of A Text Box To 2

Mar 9, 2013

I have set the decimal place property of a text box to 2. Then when i run a query that puts data in that box, the deci places are still well over 2..It lokks to be over riding it, how do I stop this?

View 4 Replies View Related

Adding Decimal Place To Integer Field

Jun 9, 2015

Successful in loading an Access database with data from the PLC's memory. Unfortunately, I'm only able to transfer Integer values. In the database I'd like to show one of the fields as a real number by formatting the Integer value to add a decimal place. Example: 2505 to 250.5

View 11 Replies View Related

Problems With Decimal Place In Query, Table And Report

Aug 9, 2007

i want my data to have only 2 decimal places. So i change the property of the table to only allow 2 decimal places and i did the same to the report and they are still all over the place....for example a field would say 8.12233444 and another 1.17.....what do you think is the problem?

View 3 Replies View Related

Modules & VBA :: Losing Decimal Place In Mail Merge

Sep 4, 2013

My DB is merge in a currency field set to 2 decimal places into word. It's doing this by declaring the fields as variable, calling an instance of work then dropping the values into the bookmarks. All works fine....

When a value is 360.64 is fine, but when it's something that ends with a 0 (360.60) - is loses the 0 giving me 360.6.

View 2 Replies View Related

Queries :: Exporting Currency Field Without Decimal Place?

May 1, 2015

I need to export a currency field to include the pence but without the decimal place, is this possible?

It also needs to be 11 characters wide.

I have tried a number of formats and can get the decimal point removed but I am not getting the pence displayed.

View 5 Replies View Related

General :: Calculation On Form - Force 1 Decimal Place At All Times

May 7, 2014

I'm using a calculation on my form that subtracts one number from another and stores the difference between the two in a 3rd field. This works correctly but I want the difference to show 1 decimal place at all times.

So for instance if subtract 35.1 from 35.2 I get a difference of "0.1".

But if I subtract 35.0 from 36.0 I get a difference of "1".

The first case is fine but I need the difference to be "1.0" in the second case.

I've set the number of decimal places in the table from auto to 1 and changed the format on the form to a standard number with 1 decimal place. Neither of these show a difference of 1 as "1.0"

How to force 1 decimal place at all times?

View 3 Replies View Related

PivotChart Decimal Place On Fixed Number Format On Averaged Field

May 18, 2006

I have a pivotchart which I cause to take a huge list of people's test percentiles and calculate the average for each year. I then display the average above each bar. The problem is that there are too many numbers after the decimal place for each figure. I went into the properties and changed the number format to "fixed" but it doesn't give me the option to change the number of decimal places that are used (it does every where else in MS Office!). It seems that it just uses the regional settings for the computer. But the problem I have in changing that is that I have other pivotcharts in the same report that does something similar but needs a different number of decimal places. Is there any way around this without having to create another query to calculate the average and then having the pivotchart display the info from the new query (this is a huge database that I put together with many charts and I don't want to have to redo the way that it works just because of this decimal place issue)?

View 1 Replies View Related

Modules & VBA :: Getting Age In Years With One Decimal Place (3.5 Years)

Mar 24, 2014

I have a table that lists computers I want to know the age of them for replacement purposes. I am using this function to populate a textbox on a form that updates my table. the results I am getting is a negative whole number I would like to get a positive number with one decimal place. so if computer was shipped September 24, 2010 my textbox would say 3.5 not -3

Here is my function

Code:
Private Sub Form_Load()
Dim theDate As Date
Dim age As Integer
theDate = Nz(Me.compDate.value, 0)
If theDate > 0 Then
age = DateDiff("yyyy", Now(), theDate)
Me.compAge = age
End If
End Sub

View 4 Replies View Related

Combo Box Restrictions

Feb 12, 2007

Background:
I'm doing a database for a camp
They can only have 96 children for any given week of camp
I have a combo box that the data entry clerk uses to assign weeks (1, 2, 3, etc)

Question:
Is it possible to make it so that I can limit how many entries (campers) are selected to attend a week of camp? So that only 96 entries can have week 3 selected?


Hope this makes sense!

Ron

View 2 Replies View Related

Restrictions For Different Users

Dec 6, 2011

I have my data base splitted in to front/end. There's login form implemented retrieving username and password from a table. There're couple of restrictions like: admin - can delete records; non admin - can't delete records. But my main purpose is to have such restriction that each front user will see the data entered by him only and back end should reflect all data entered by different front end users.

View 7 Replies View Related

General :: How To Calculate Fields With Restrictions

Apr 10, 2015

Here is an explanation of my database and what I am trying to accomplish. The tables and their fields I have in the database are as follows .....

EmployeeT
EmployeeID - Primary Key - Number (not an autonumber because they are county assigned)
LastName - Text
FirstName - Text
EmailAddress - Text
JobTitle - Text
MobilePhoneNumber - Text
Notes - Memo

[Code] .....

All users will interface with a form that will fill in data on the TransactionT table. I would like the data that is being input into the TransactionT.Quantity field to change the data ItemT.ESBuildingQty or ItemT.D3Qty based on which is chosen from StockLocation (they will only be able to choose either "ES Building" or "D3" when inputting the data).

For example, if the stock amount at the ES building of a particular item is 3 and the stock amount of that same item at D3 is 1 and a user inputs that a quantity of 3 of a specific item are taken from ES Building and Added to D3, I want the new values of ESBuildingQty to be 0 and D3Qty to be 4.

View 11 Replies View Related

Round Up Decimal Point To 4 Decimal Places

Jun 2, 2005

Hi there,

I am not sure the best way to do this,

I have a field with values that look like: 1.69553366385509 or 0.0061705541157596

I want these values to look like: 1.6955 or 0.0062 (4 decimal places [rounded up if possible])

Thanks for your help with this

Sue

View 5 Replies View Related

Is It Possible To Place Cursor ?

Dec 7, 2005

Hi,

In a form a have a field wich contains for exemple 'ABCD', is it possible to place focus in this field after the last character (after the D in my exemple).
Thanks in advance.
VINCENT

View 2 Replies View Related

Best Place For Code

Oct 29, 2006

Hi again, This might be a simple answer, but I have tried several event properties, the last in the OnCurrent of the main Form. But most of the calcs work most of the time, and occassionally I get an 'Error 2001'. I have a couple of years VBAing, so still a teenager?? I am curious as to wether I am placing the calcs in the right event. I really only want them to do the calcs when the leave tab is selected (see enclosed image) and/or if a new employee record is navigated to. I will also attach code of calcs. If it needs to go into the Tab control what is the best event?
NB pink fields on form are visible=No and for troubleshooting

Coding:
' Run Calcs here for Leave other than Sick Leave.
If IsNull(EmpStartDate) Then
DaysWorked = 0
Else
DaysWorked = DateDiff("d", EmpStartDate, Now)
End If
' Calc number of days between Employee Start Date and Now

TotalLeaveAlloc = DaysWorked * (Me!AnnualLeaveDue / 365)
' Divide Allocated days by 365 and multiply by number of days worked

If IsNull(DSum("[DaysTaken]", "[qryLeaveRecords]", "[LeaveType]<>'Sick' And [tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")) Then
TotLeaveRecorded = 0
Else
TotLeaveRecorded = DSum("[DaysTaken]", "[qryLeaveRecords]", "[LeaveType]<>'Sick' And [tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")
End If
' Calculates the number of leave days taken from leave records in database based on qryLeaveRecords
' Used IsNull to check if there are no records found - set calc result to zero

Me.Taken01 = TotLeaveRecorded 'visible option = no
' Display this on screen

If IsNull(Me.LeaveAccrued) Then
LeaveBalance = TotalLeaveAlloc - TotLeaveRecorded
Else
LeaveBalance = TotalLeaveAlloc - (TotLeaveRecorded + Me.LeaveAccrued)
End If
' Check if there is any Accrued Leave [reduces the need to load historical Leave Records] and subtract them

Me.Bal01 = LeaveBalance
' Display Balance

' Run Calcs for Sick Leave here.
If IsNull(DSum("[DaysTaken]", "[qrySickLeaveRecs]", "[tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")) Then
TotSLeaveRecorded = 0
Else
TotSLeaveRecorded = DSum("[DaysTaken]", "[qrySickLeaveRecs]", "[tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")
End If
' Calculates the number of leave days taken from leave records in database based on qrySickLeaveRecs
' Used IsNull to check if there are no records found - set calc result to zero

Me.Taken02 = TotSLeaveRecorded 'visible option = no
' Display this on screen

Me.Bal02 = Me.SickLeaveDue - TotSLeaveRecorded
' Display Sick Leave Balance

thanks in advance ...

View 8 Replies View Related

Cheapest Place To Get Access?

Aug 11, 2007

Hey all

I'm looking to get Access 2007. Anyone know the cheapest place to get it? I'm in UK but if importing is cheaper I'd be interested.

Thanks for your help

View 7 Replies View Related

HOW NOT To Send 2 Envelopes To The Same Place

Jun 14, 2006

Hey everyone,

I'm playing with my DB a bit and I need help in determing which way to go. When I print out labels for Envelopes or directly on envelopes, sometimes I have people living on the same address (a family), so I would like to save some on printing and actually sending several envelopes to the same address.
Now, I was thinking of doing this through the code in VBA but now I'm thinking if there is maybe more simple and faster way in building a qry.

All the data for the labels and envelops comes to a temp table from where I'm printing out reports...so what I'm not sure, is there a way to make a querry which would go through my temp table sorted by address, pick address1 then address2, if they are the same, check if lastname1 and lastname2 ise the same and then name1=name1 & Name2, delete record2 and go on...

tnx a lot

View 2 Replies View Related

Rounding Two Place Holders.

Mar 4, 2008

My sql code reads as follows:

Total ATR: Round([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) & "%"

This will round to a whole.

When I try to set it to round to the tenth it fails.
I tried using
Total ATR: Round((([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) & "%"),2)

Any ideas?

View 3 Replies View Related

Race Finish Place

Jan 17, 2006

Is there an easy way of doing this? I have a database that I want to automatically place racers as they finish. I have four race divisions. All racers no matter the division start at the same time. I have all of this figured out, but what is getting me is the finish place (1st, 2nd, etc.) Is there a way on a continuos form to automatically place the racers? How this works is...Main form has racer info., on this form is a stop button, and after the button is clicked, it will show his/her finishing place in their division which is subform of the main form. Here is the reason I want this. Someone may have registered wrong and they are in the wrong division, and we have to change them to the correct division after they have finished and already been placed. I want to be able to move them to the right division, and then my subform requery and they placed in the correct position in the new division. Sorry this is so lenghty. Plain and simple can I make a subreport have an unbound field that shows each records place the recordset? Thanks for your help, and like I said sorry this is so long.

View 4 Replies View Related

How To Place A Form Into PowerPoint Using VBA

Sep 3, 2012

I have made a powerpoint presentation from inside Access. I have a form that populates the fields based on user input. I would like to put a copy of this form into a powerpoint slide after the data has updated. Is there a way to do this?? I have tried numerous code variations and can't seem to get anything to work.

I am using Office 2003. My supervisors are comfortable with the display of the form the way it is. So I really need to use a picture of the form and not just the info contained in the form (otherwise i would just fill the slide with the data from the query)...

View 4 Replies View Related

Normalization And Relationships - Don't Know How To Place Data

May 31, 2005

Hi, I want to create an access app that will allow a user to see the number of pages printed by various printers.

These are the data that I have:
Model Type (various are available)
Printer's name (unique to one printer)
IP addr (unique to printer)
Quantity printed (such as Single Legal, Double Legal, Single Letter,etc)

This is what I have (2 tabels with 1-many relationship):
Printers
PrinterID
Model
Name
IP

ModelTypes
ModelID
Model

Now, where do I place the quanties of paper printed? Do I just leave it in Printers?

Thanks.

View 9 Replies View Related

Can I Place A A Command Button In A Query?

Apr 13, 2007

Hi,

I have a query that is run off a form. When the query opens up there is a field you can enter data into. Once you close the query the data saves into the proper place in the table. That all works great.

I'm trying to make this as user friendly as possible. Instead of having someone go up to the "x" in the top right hand corner to close the query can I place a command button in the query that is very noticeable?

Any thoughts are most welcome

Thanks

Eddie.

View 2 Replies View Related

Refresh Subform Without Losing Place

Feb 10, 2005

Hello,

I have a subform that is based on a SQL statement that sums by Dollar Amount and groups by Account. I have it set up so the user can double-click on an account, which opens an unbound form. I then have the form execute a SQL INSERT INTO statement, which works beautifully.

The form opens as a pop-up, and I have it requery the subform when it closes. However, when the pop-up closes, I go back to the first record on the sub-form. I need it to "remember" the record I was on and take me back to that one. What is the standard procedure for doing this?

Thanks in advance!

Eric

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved