Re: Access - ODBC to SQL - Incorrect Results

On Nov 19, 7:49 pm, Jensen.Ka...@xxxxxxxxx wrote:

My question was why 3 fields defined as the same thing in SQL server
holding the same format of data are acting differently in ACCESS.

This is one of those questions that is very difficult to answer
because it is so general, like "Why the sea is boiling hot" and
"Whether pigs have wings?"

Questions:
1. yyyy-mm-dd is 10 characters long. Why Varchar(20)?
2. Why yyyy-mm-dd rather than yyyymmdd? "-" has significance to many
search and filter engines beyond being a hyphen. It adds zip of
significance to yyyymmdd.
3. You say the data are in SQL server. You also say the data were
imported form SQL-Server. And you say, why won't what I want to
happen, happen in Access. Where are the data? And how are you
connecting? And what does in Access mean: on a form? in a recordset?
In the returns of a query? WHAT?

It sounds to me as if you are in too deep here. If you tell us some
specifics we might be able to help. I don't use ODBC but I've been
convinced of its effectiveness. It should be able to take your Access
commands and translate them into MS SQL-Server SQL that will give you
the results you need.

BTW. X-Base programs translated dates to yyyymmdd for sorting purposes
for years and years and years with no problems. Probably they still
do. So there should be no unsolvable problem in your using this
format. But I would create another date column and cast the yyyymmdd
strings to dates and use that. Why use a 13.5 compression ratio V-12
and give it regular gas ... or sub-regular gas?





.

Relevant Pages

  • Re: Wildcards in einem Parameterwert
    ... > abgesegnet wurde und nur von Amis erfunden werden konnte. ... Bei denen ist es bewusst Text im Format ... YYYYMMDD, genauer "Text der nur Ziffern enthalten darf" (Datentyp ...
    (microsoft.public.de.access)
  • Re: Storing dates
    ... If you must use a text field, you can use Format, "yyyymmdd") to ... get today's date in that format. ... Estoy utilizando la versión gratuita de SPAMfighter para usuarios ... Ha eliminado 454 correos spam hasta la fecha. ...
    (microsoft.public.access.forms)
  • Re: Date Format
    ... Is the field data type definitely a DateTime? ... Input mask only constrains user keystrokes, ... can have any output format you want. ... > I open the form the date reverts back to the yyyymmdd format, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Storing dates
    ... But how would I populate a field today_date with Format, "yyyymmdd") ... get today's date in that format. ... Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados. ... Ha eliminado 454 correos spam hasta la fecha. ...
    (microsoft.public.access.forms)
  • Re: Word - Different Date Formats Available
    ... Yes the long format is correct, I've checked rginal settings and language settings in Office. ... I believe I've found an unsolvable problem. ... "Beth Melton" wrote: ...
    (microsoft.public.office.misc)
Loading