Help needed with FV in form.

ldare2000

Registered User.
Local time
Today, 15:17
Joined
May 11, 2009
Messages
12
Hi,

I've inserted a Text box and want to use the FV formula as I do in Excel is this possible? Acess doesn't like me inserting the following into the text box

=FV(1%, [Text45],0,[Total],0)

Thanks
Louis
 
Hi,

I've inserted a Text box and want to use the FV formula as I do in Excel is this possible? Acess doesn't like me inserting the following into the text box

=FV(1%, [Text45],0,[Total],0)

Thanks
Louis
The function is okay to use but you have 1% in instead of .01 which is the number you need.
 
Hi,

One more quick one...

Should this work in an Access form text box :
=ROUNDDOWN([Days]/30)

Thanks
Louis
 
Hi,

One more quick one...

Should this work in an Access form text box :
=ROUNDDOWN([Days]/30)

Thanks
Louis

As ScooterBug posted, use Round as there is no RoundDown function in Access.
 
If you need to round down all the time, you will have to use a bit of code as well. I do something similar here at work. I have to round a number up. You would use something like this:

Code:
dim sinResult as single
dim sinRounded as single
 
sinResults = [days]/30
sinRounded = round([days]/30,0)
 
if sinRounded < sinResult then
   sinRounded = sinRounded - 1
end if

I deleted my previous post...I wanted to get all the correct info in...but Bob saw it before I deleted...that or he's psychic :)
 
No, that would be psychotic :D

Cool.

One last one :-)

I need to create a value based on todays date and the date an invoice was paid. But if the invoice is unpaid and the [Date Paid] is blank I need this days since paid to be 0 rather than blank.

The following doesn't work but should give an idea to what I want to do?

=Date()-[Date Paid] Or =0 IF ([Date Paid] = null)

Am I way off here?

Thanks so much for all the help today!
Louis
 
How about:

=IIf(IsNull([Date Paid]),0,DateDiff("d", Date(), [Date Paid]))
 
WOW thanks :-)

Sure thing

yourewelcome3.jpg
 
If you need to round down all the time, you will have to use a bit of code as well.

There is a simpler way.

Use the Int() function when the rounding requires zero decimal places.
It returns the integer part of the expression.

Rounding down:
Int(expression)

However be acutely aware of the danger when using any up or down rounding technique. Small discrepancies can be hugely exaggerated.

Input expressions resulting in numbers like 1.9999 can occur when 2.0000 is expected and will round down. Scooterbug's technique could also be vulnerable in some situations (though not the exact circumstance in this thread).

A safer expression for rounding down where there is any risk is:
Int(expression + 0.0009)

Use as many zeros as the required precision.
0.09 will round down from #.9
0.009 will round down from #.09

This avoids results like 1.999 being rounded down.

Rounding up:
Int(expression + 0.999)

Include as many nines as precision required.
0.9 will round up numbers from #.1
0.999 will round up numbers from #.001

This avoids results like 1.0001 being rounded up.

With decimal calculations use double precision numbers if accuracy is essential. Single precision numbers become unreliable from about three decimal places and failing to account for these small discrepancies can lead to unexpected results especially when rounding up or down.

Also note that the Round() function uses banker's rounding which favours even final digits in the result. For example the numbers 1.5 and 2.5 both round to 2.

It is a better method than the ill-conceived arbitrary "always round up the five digit" we were taught in school because it tends to level out the errors when multiple roundings are processed.
 

Users who are viewing this thread

Back
Top Bottom