MS Access 2003 Record Filter Problem

[Adeem Zashir]

Hi,
I have developed an application using VB 6.0 as Front-End and MS Access DB
as Back-end. I have been using the quries ( with Where Predicate) to Filter
the data as per requirement. I have Experience a Some Strange Behaviour in
this regards. When The Application is processing the Operator based
Transactions in real-time. When I Execute Query filtering on the Operator ID
and Trasnaction time, it, moslty, skips 1 or 2 records. But when I execute
the Same Query, by just Excluding the OperatorID, it returns me all the
relevnat records? This is somethign very critical to me as the apllication is
realtime and keep Financial Info. Due to this issue, the User is MOSTLY
UNABLE TO Reconciel the Financial Data? I need your advice in this regards

 

[Tom van Stiphout]

On Wed, 18 Mar 2009 23:31:12 -0700, Adeem Zashir <Adeem
(e-mail address removed)> wrote:

What are the data types of OperatorID and TransactionTime in the
table? What is the query you're trying to execute?

-Tom.
Microsoft Access MVP

 

[Danny J. Lesandrini]

Could it be due to NULL values?

Seems unlikely that your OperatorID would be null and if TransactionTime is
stamped on it, then that is probably always populated.

If you're going from VB, you're probably passing the SQL via ADO, right?
From Access, it's using Access syntax. Could be a difference there. Can you
post the SQL?