Date is closer to number than to text.

Post #143,090 by CRConrad 2/24/04 5:04:04 PM Reply	Date is closer to number than to text. The Nightowl plaintively hoots: They only give me date/time as an option, or text, or number. I don't see anything where I can customize the date. Grrr. Sheesh, woman, DO try to learn to read a bit more constructively -- everybody has been talking about the NUMBER datatype as an alternative. You just enter a number that happens to ALSO BE a date, seewhatimean? Then you preferably add a constraint (look up that word in the help; if it isn't there, it's the help file that sucks, not my advice; then you'll have to think of all the synonyms for "constraint" that you can imagine, and try those) that says the value in this number field has to be between, say, 19000000 (nineteen million) and 21000000 (twenty-one million). Your choice as to whether the constraint is on the data table itself, the editing window, or wherever else Access lets you put it... But "your choice" doesn't necessarily mean that it's unimportant; think a little about which would be the most logical and sensible place to put it. And if you go that way, for all that is good and holy in the world, DO follow Ben's suggestion to use the YYYMMDD format, NOT the idiotic American MMDDYYY one. (In case you're wondering why, think about sorting.) () I thought about making one column the year, and the next the date, would that work, is that what you are explaining, Ben? That would also work(), but would be a bit more work to make into a whole date for reporting, sorting, and comparing... With the single-number format (which Ben SAID he was talking about; learn to frigging READ, woman!), you get the opposite problem of grouping on just the year or month portion of the number. On balance, though, I tend to agree with Ben that the single-number model is easier and better. My biggest problem is that I wanted the database to sort by date, (date and year), and this is causing the 1974's not to follow that sort pattern, well, it won't even take them without some date. Grrr. So why on Earth hasn't it occurred to you to just use some fake date?!? Preferably one that isn't too likely to be an actual true date... Like, how often do you finish a book on Christmas Day? Or, say, New Year's Day? (Even if you DO occassionally do that, just lie and pretend that you finished those ones on the second of January.) If you go with the number-as-fake-date idea, you can of course say 'YYYY0000' where you can remember only the year, or 'YYYYMM00' where you have the month but lack the day. And yes, I want to learn about it, by query do you mean making a report? If I wanted to look this up in my book, any idea what to look under? There is nothing under customize data type. Tried looking under "Query"? (Again, if it isn't there, the help file sucks.) Sheesh, ever tried just BROWSING a book; flip a few pages at a time and skim, until you get to something that looks like it could be approximately what you're after, then slow down and flip somewhat fewer pages at a time and skim somewhat more thoroughly, until you're actually reading a page that is actually about what you were after? If not, it's high time you started; knowing how to do that is really the least that can be expected of anybody over, say, twelve. HTH! (): And in case you've ever wondered about the "It's MIDDLE-ENDIAN!" LRPDism, wonder no more -- it's about the US date format. (): Provided you actually meant "thought about making one column the year, and the next the month, and the next the day of the month"; what would "and the next the date" be supposed to mean, otherwise? Yet another column with the same problem you already have...? [link\|mailto:MyUserId@MyISP.CountryCode\|Christian R. Conrad]** (I live in Finland, and my e-mail in-box is at the Saunalahti company.) You know you're doing good work when you get flamed by an idiot. -- [link\|http://www.theregister.co.uk/content/35/34218.html\|Andrew Wittbrodt]
Post #143,094 by Nightowl 2/24/04 5:31:03 PM 2/24/04 5:36:45 PM Reply	Re: Date is closer to number than to text. Sheesh, woman, DO try to learn to read a bit more constructively -- everybody has been talking about the NUMBER datatype as an alternative. You just enter a number that happens to ALSO BE a date, seewhatimean? When I change the datatype to number, it bunches all the numbers up and it no longer looks like a date, plus it takes away the whole year and only gives me the last two digits. Then you preferably add a constraint (look up that word in the help; if it isn't there, it's the help file that sucks, not my advice; then you'll have to think of all the synonyms for "constraint" that you can imagine, and try those) that says the value in this number field has to be between, say, 19000000 (nineteen million) and 21000000 (twenty-one million). Your choice as to whether the constraint is on the data table itself, the editing window, or wherever else Access lets you put it... But "your choice" doesn't necessarily mean that it's unimportant; think a little about which would be the most logical and sensible place to put it. I found constraint, but can't seem to locate the Query tab which is what it's telling me to use. I'm looking for it now. And if you go that way, for all that is good and holy in the world, DO follow Ben's suggestion to use the YYYMMDD format, NOT the idiotic American MMDDYYY one. (In case you're wondering why, think about sorting.) () I would LOVE to change the format like you are suggesting, but that was my original problem, I can't find anywhere to change the date format to something else. That is what I'm looking for. On balance, though, I tend to agree with Ben that the single-number model is easier and better. I do too, and I would rather go with it. My biggest problem is that I wanted the database to sort by date, (date and year), and this is causing the 1974's not to follow that sort pattern, well, it won't even take them without some date. Grrr. So why on Earth hasn't it occurred to you to just use some fake date?!? Preferably one that isn't too likely to be an actual true date... Like, how often do you finish a book on Christmas Day? Or, say, New Year's Day? (Even if you DO occassionally do that, just lie and pretend that you finished those ones on the second of January.) Edit: I was thinking about making up dates, but really didn't want to. If you go with the number-as-fake-date idea, you can of course say 'YYYY0000' where you can remember only the year, or 'YYYYMM00' where you have the month but lack the day. I'm hoping that will work if I can get the format changed to YYYYMMDD. That's what I can't seem to find, is an option to select that format. Sheesh, ever tried just BROWSING a book; flip a few pages at a time and skim, until you get to something that looks like it could be approximately what you're after, then slow down and flip somewhat fewer pages at a time and skim somewhat more thoroughly, until you're actually reading a page that is actually about what you were after? If not, it's high time you started; knowing how to do that is really the least that can be expected of anybody over, say, twelve. Yes, I've been browsing it, but I'm not sure what the thing I want to do is called, so I'm not locating much. I"m still browsing it though. I'm still trying to solve the problem, of course, I don't know for sure that Access can accomplish it, but I believe it probably can. I'm still learning what Access can do. Thanks for your input. Nightowl >8# "To become different from what we are, we must have some awareness of what we are." Eric Hoffer* Edited by Nightowl Feb. 24, 2004, 05:36:45 PM EST Expand All History
Post #143,095 by Nightowl 2/24/04 5:39:47 PM 2/24/04 5:48:50 PM Reply	Okay, I got out the really technical book But the only place I can find where I can change date format is in Excel. There isn't anything about being able to do it on Access, and this book is Microsoft Office '97 Professional. Is it possible that I can't change the date format in Access???? Edit: Never mind, I called my brother, who is pretty good with Access, and he explained that I have to hit F-6 to get to the options. Not sure why it didn't say that in the stupid book. Nightowl >8# "To become different from what we are, we must have some awareness of what we are." Eric Hoffer Edited by Nightowl Feb. 24, 2004, 05:47:43 PM EST Edited by Nightowl Feb. 24, 2004, 05:48:50 PM EST Expand All History
Post #143,098 by Nightowl 2/24/04 6:00:30 PM 2/24/04 6:01:08 PM Reply	Stupid Book Finally found it on page 644, but it doesn't say anything about how to get to the box to change it, just that you can. Also it says you can make custom formats, but doesn't tell you how. I wish someday someone would make a manual that really HELPS! Nightowl >8# Edit: changed people to someone. "To become different from what we are, we must have some awareness of what we are." Eric Hoffer Edited by Nightowl Feb. 24, 2004, 06:01:08 PM EST Expand All History
Post #143,105 by rickw 2/24/04 6:16:00 PM Reply	Re: Stupid Book That has to do with how and why big computer books are written and sold. The only entity that really has any interest at all (even though they are uninterested) in writing good doc for access is, well, microsoft. (yes, I know, nobody has to tell me about how access doc really is). Usually, as here, the cynical explanation is the preferred on (hi ashton). WWJD? JWRTFM.

Welcome to IWETHEY!