| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 30096 | 2003-02-10 07:36:00 | Microsoft Access 97 | alantelfer (2904) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 119991 | 2003-02-10 07:36:00 | I have a spreadsheet which tracks when maintenance is due for electronic equipment. In EXCEL "Cells" A1 = Install Year B1 = Input Year (year to check if maintenance due) C1 = Maintenance Cycle (years) D1 = Calculation to determine if Maintenance due. Formula in D1 is =IF((($B$1-$A$1)/C1)/ROUNDUP(($B$1-$A$1)/C1,0)=1,TRUE,FALSE) The formula calculates if the "Install Year" plus multiples of "Maintenance cycle" equals "Input Year" then maintenance is due. Using the abobe formula allows for the calculation to work for any year with no time limit. I have built an ACCESS database to make everything more flexable but have a problem !!! I cannot find a formula to duplicate the formula I used in EXCEL. The "ROUNDUP" or even "ROUND" function does not appear to be part of ACCESS. |
alantelfer (2904) | ||
| 119992 | 2003-02-10 09:11:00 | Have a look at the MOD operator. A Mod B returns the remainder of A divided by B. If the remainder is zero A is a multiple of B :| | wuppo (41) | ||
| 119993 | 2003-02-13 10:00:00 | Thank you Wuppo using if(B - A) MOD C = 0 , big service, minor service resolved my problem | alantelfer (2904) | ||
| 1 | |||||