Re: Different results in SQL and Access

Bob,

When quoting, please use the quote in its entirety:

"After reading all your kind suggestions, I think I'll never use
Access to select records from SQL via Date/Time again. "

I'll certainly continue to use MS-Access for lots of good reasons

Kind Regards,
Pat Backowski



If you are

"Bob Barrows [MVP]" wrote:

By "sql/vb", do you mean using a recordset to loop through and select your
data?? <gasp>

Or do you mean using ADO to execute your sql queries (which would certainly
be acceptable)?

I still don't understand why you are blaming Access for the failure of your
incorrectly-constructed query*. The query I suggested you use should be the
same query you should use in your ADO code.


* and before you say "I'm not blaming Access", the statement "I'll never use
Access again" certainly carries the implication of blame.

Pat Backowski wrote:
Hi Bob,

I appreciate your suggestion, but I need to reliably select data by
the hour as well as the day.

In a commercial sense, we've fallen flat on our face and I can't take
the risk of another failure.

So, for various reasons, the sql/vb approach has merits.

Regards,
Pat

"Bob Barrows [MVP]" wrote:

Pat Backowski wrote:
My,oh,my

Quite a discussion regarding the storage and selection of date/time
access vs sql server.

Thanks to you all. - Yes I am using a linked table and Yes there is
time involved.

After reading all your kind suggestions, I think I'll never use
Access to select records from SQL via Date/Time again.

Why? My first suggestion should work ...
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Re: DateTime Error :: Implicit Conversion
    ... >> Use SQL Profiler to see what is actually getting sent to your sql ... > I have tried this suggestion but it still also does not alleviate this ... CREATE PROCEDURE script I will try to reproduce your symptoms, ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Multi-step OLE DB operation generated errors
    ... I think the reason it hasn't solved is that this database has the ... Doesinterbaseprovide a trace tool like MS SQL Server's Profiler? ... Please reply to the newsgroup. ... This email account is my spam trap so ...
    (microsoft.public.data.ado)
  • Re: Problem w/ VBScript running against SQL Server 2000
    ... but bayID is always assigned the value of bay_id. ... account for sql injection anyway. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Issue with retrieving large data over web using Stored Procedu
    ... other improvements I could do at the ASP page? ... how do I go about analyzing a stored procedure with selecting ... Is there any tool in the SQL Profiler that analyze each Trace? ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.db)
  • Re: Different results in SQL and Access
    ... do you mean using a recordset to loop through and select your ... Or do you mean using ADO to execute your sql queries (which would certainly ... This email account is my spam trap so I ...
    (microsoft.public.access.queries)