If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
what expression to use to show years between to dates, and to sho.
I have tried many expression to resolve this, but when the difference is
under 1 year, it adds on year to the table am making from this query. |
#2
|
|||
|
|||
The difference betweeen what and what? What do you mean when you say it add
a year to the table? "Web" wrote: I have tried many expression to resolve this, but when the difference is under 1 year, it adds on year to the table am making from this query. |
#3
|
|||
|
|||
Not sure what you are trying to accomplish. You might do a search for
"calculate age" and you should find many posts (several from me) that include the formula to calculate someone's age. BUT.... You would not store this in your table. If you store a date in the table, you don't also need to store the age (as it will change every year). Calculated fields are redundant and should not be stored in the table. When you need the calculation, you calculate it in your form, report, or query. One other problem with trying to store a calculated field is what to do if the original field changes. If you enter someone's birthday and calulate their age, what happens if you find out the birthday is wrong and you correct it? Post an example and more details if this does not address your issue. Rick B "Web" wrote in message ... I have tried many expression to resolve this, but when the difference is under 1 year, it adds on year to the table am making from this query. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I wnat a table displaying all dates 2 years from the current date | Mike | Database Design | 1 | November 17th, 2004 07:37 PM |
Difference in years and months between 2 dates | Els | General Discussion | 2 | October 1st, 2004 03:12 PM |
finding the difference in years between dates | Worksheet Functions | 5 | August 19th, 2004 10:58 PM | |
CALCULATE FUTURE DATES | Michael J. Malinsky | Worksheet Functions | 5 | February 5th, 2004 05:42 PM |