Why would you use >1 in the criteria field of query

[Guest]

Hi, i am missing data in some of my reports. I check my queries and some of
them have >1 in the criteria of some of the fields ie: (fldDate orautoNo)

 

[Jeff Boyce]

Who created the queries?

What kind of data is stored in the "fields"?

What is the expected output of the queries?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

A friend of mine, he does not work in the shop any more. The data in the
query is date of an event, then it assign a autono. But when i go to the
table that has all the info the first file that is in the table is not in the
query. The query combines the data from a table and other event informations.

 

[Jeff Boyce]

I'm afraid I still don't have nearly enough information to offer any
specific suggestions.

Perhaps one of the other readers in this 'group can offer ideas...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[David F Cox]

It might be a fudge to eliminate nulls. A lot of people do not understand
them.

 

[Jeff Boyce]

Thanks, David. That sounds plausible...

Jeff

It might be a fudge to eliminate nulls. A lot of people do not understand
them.

 

[John Vinson]

Hi, i am missing data in some of my reports. I check my queries and some of
them have >1 in the criteria of some of the fields ie: (fldDate orautoNo)

This will retrieve all records where the field has a value greater
than 1; records where the field is negative, zero, equal to 1, or (for
date/time fields) prior to December 31, 1899 will not be retrieved.

Since we have no way to know anything about the datatype, contents, or
meanings of fldDate or orautoNo, it's more than a bit difficult to
suggest whether this criterion is sensible or not in your context.

John W. Vinson[MVP]