A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

what expression to use to show years between to dates, and to sho.



 
 
Thread Tools Display Modes
  #1  
Old January 12th, 2005, 01:17 PM
Web
external usenet poster
 
Posts: n/a
Default 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  
Old January 12th, 2005, 02:17 PM
BruceM
external usenet poster
 
Posts: n/a
Default

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  
Old January 12th, 2005, 03:52 PM
Rick B
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.