IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Solved it!
Post #143,122
by Nightowl
2/24/04 8:27:56 PM
Reply
New Solved it!
John helped me figure out how to make a customized field.

We took a text field and gave it an input mask of 0000\\-00\\-00

It's finally working, YAY! Thanks for all the help.

Nightowl >8#

"To become different from what we are, we must have some awareness of what we are."
Eric Hoffer
Post #144,163
by orion
Picture of orion
3/2/04 5:24:35 PM
Reply
New You could have entered a date
with the year and like 1/1/2004 and then ignored the day and month. When doing a query you can do a Year([DateColumn]) where DateColumn is the name of the field you put the date into and then sort by that.

As others suggested, you could have created a number field of four digits and then sorted by that. Would have been a lot easier for you.

Text fields take longer to sort by, numbers are faster to sort by. If you get a lot of records the database is going to bog down in speed when sorting by that text field. If it is a small database, you may not have to worry about it.


"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"
     I'm playing with Access - (Nightowl) - (13) - Feb. 24, 2004, 02:53:47 PM EST
         Number format? - (deSitter) - Feb. 24, 2004, 03:02:27 PM EST
         data type - (Steve Lowe) - Feb. 24, 2004, 03:05:22 PM EST
         What Steve said - (ben_tilly) - (6) - Feb. 24, 2004, 03:12:24 PM EST
             Data Types - (Nightowl) - (5) - Feb. 24, 2004, 03:59:25 PM EST
                 Date is closer to number than to text. - (CRConrad) - (4) - Feb. 24, 2004, 05:04:04 PM EST
                     Re: Date is closer to number than to text. - (Nightowl) - Feb. 24, 2004, 05:36:45 PM EST
                     Okay, I got out the really technical book - (Nightowl) - (2) - Feb. 24, 2004, 05:48:50 PM EST
                         Stupid Book - (Nightowl) - (1) - Feb. 24, 2004, 06:01:08 PM EST
                             Re: Stupid Book - (rickw) - Feb. 24, 2004, 06:16:00 PM EST
         My aggregate reply - (rickw) - (1) - Feb. 24, 2004, 06:08:29 PM EST
             Re: My aggregate reply - (Nightowl) - Feb. 24, 2004, 08:46:15 PM EST
         Solved it! - (Nightowl) - (1) - Feb. 24, 2004, 08:27:56 PM EST
             You could have entered a date - (orion) - March 2, 2004, 05:24:35 PM EST

I just KNEW the Good Humor Man was behind this...
46 ms