Query Criteria is not working

I am having an issue with the criteria of a query.

I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is 0

With the above scenerio, I get no loads which are 0, but I still get account
codes 4125 and 4121.

If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.

Any ideas?
Cahd

my mistake.
I needed to use NOT = 4125 AND NOT = 4121

thanks
Chad

"Chad Cameron" remove NOT wrote in message
...
I am having an issue with the criteria of a query.

I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is 0

With the above scenerio, I get no loads which are 0, but I still get
account codes 4125 and 4121.

If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.

Any ideas?
Cahd

Hi Chad,

Why don't you post the SQL of your query and then someone can easily help
you.
Open your query in the query design panel and right click on the top bar
and choose sql view.
copy that text and post it in a message.

Regards

Kevin


"Chad Cameron" remove NOT wrote in message
...
I am having an issue with the criteria of a query.

I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is 0

With the above scenerio, I get no loads which are 0, but I still get
account codes 4125 and 4121.

If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.

Any ideas?
Cahd

The account code criteria needs to be --
4125 AND 4121

--
Build a little, test a little.


"Chad Cameron" wrote:

I am having an issue with the criteria of a query.

I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is 0

With the above scenerio, I get no loads which are 0, but I still get account
codes 4125 and 4121.

If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.

Any ideas?
Cahd



.

On Tue, 9 Mar 2010 15:41:50 -0800, "Chad Cameron"
remove NOT wrote:

I am having an issue with the criteria of a query.

I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is 0

With the above scenerio, I get no loads which are 0, but I still get account
codes 4125 and 4121.

If you use OR, then you'll get all records because 4125 is in fact not equal
to 4121, and vice versa.

If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.

I have no idea what you mean.

Try a criterion on account code of

NOT IN(4121, 4125)

--

John W. Vinson [MVP]

"Chad Cameron" remove NOT wrote in message
...
I am having an issue with the criteria of a query.

I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is 0

With the above scenerio, I get no loads which are 0, but I still get
account codes 4125 and 4121.

If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.

Any ideas?
Cahd

kkbbb

"Chad Cameron" remove NOT a écrit dans le message
de groupe de discussion : ...
I am having an issue with the criteria of a query.

I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is 0

With the above scenerio, I get no loads which are 0, but I still get
account codes 4125 and 4121.

If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.

Any ideas?
Cahd