Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
decapitator
Starting Member
2 Posts |
 Posted - 2003-02-11 : 05:36:38
|
| Hello, I have a question about ACCESS. I need to know how to change birthdates into age, I need to know how to do this in SQL.And I also have a question about Yes-No boxes. How can I display them in a table as 1-0? also SQL please.Thnx<edit> moved to Access forum </edit>Edited by - robvolk on 02/11/2003 07:09:19 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-02-11 : 09:00:50
|
| You need an as-of date to return an age based on a birthday.Look at the DATEDIFF() function in the help menus.You can display the boolean type as a -1 or 0 by going to design view, selecting the field, and then down below click on the LOOKUP tab. Change the control displayed to a TEXT BOX. You can change the format attribute of the field to "#;#" to return a 1 or 0 by never showing the - sign. (look up format strings in help as well).- JeffEdited by - jsmith8858 on 02/11/2003 09:01:42 |
 |
|
|
decapitator
Starting Member
2 Posts |
Posted - 2003-02-12 : 04:16:04
|
| Thnx Jeff, gonna try that now |
|
|
|
|
|
|
Change birthdate into age