Criteria

B

Bob

I have a queiry where I have an expression.

USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]

I would like to have a criteria that basicly selects all records that are
greater than or less than 0..

I have tried various things and nothing seems to work.. When I put even a
simple criteria like =2 the querie as for paramaters to be supplied.

What am I doing wrong...

Thanks

Bob
 
O

Ofer Cohen

First step, replace all null values with 0, or the resault will be Null.

Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)

Second step add the criteria
<> 0
 
B

Bob

Ok thank Ofer I did just what you suggested I still get a popup box saying
"Enter Paramater Value" Net_Tot_PaY_USD then there is a place for input...

I have no idea what I am doing wrong.

Bob


Ofer Cohen said:
First step, replace all null values with 0, or the resault will be Null.

Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)

Second step add the criteria
<> 0

--
Good Luck
BS"D


Bob said:
I have a queiry where I have an expression.

USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]

I would like to have a criteria that basicly selects all records that are
greater than or less than 0..

I have tried various things and nothing seems to work.. When I put even a
simple criteria like =2 the querie as for paramaters to be supplied.

What am I doing wrong...

Thanks

Bob
Click to expand...
Click to expand...
 
D

Dale Fye

Bob,

This message (prompt) indicates that there is a field [Net_Tot_Pay_USD]
(looks like the first field in the sequence below) that does not actually
exist in one of the tables used in your query. My guess is that you either
have the field name entered incorrectly, or that it is an alias. Can you
post the entire SQL string?

Dale
--
Email address is not valid.
Please reply to newsgroup only.


Bob said:
Ok thank Ofer I did just what you suggested I still get a popup box saying
"Enter Paramater Value" Net_Tot_PaY_USD then there is a place for input...

I have no idea what I am doing wrong.

Bob


Ofer Cohen said:
First step, replace all null values with 0, or the resault will be Null.

Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)

Second step add the criteria
<> 0

--
Good Luck
BS"D


Bob said:
I have a queiry where I have an expression.

USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]

I would like to have a criteria that basicly selects all records that are
greater than or less than 0..

I have tried various things and nothing seems to work.. When I put even a
simple criteria like =2 the querie as for paramaters to be supplied.

What am I doing wrong...

Thanks

Bob
Click to expand...
Click to expand...
Click to expand...
 
B

Bob

Hi Dale the name is the name of and expression in the same query... How do I
get around that one..

Bob and thanks



Dale Fye said:
Bob,

This message (prompt) indicates that there is a field [Net_Tot_Pay_USD]
(looks like the first field in the sequence below) that does not actually
exist in one of the tables used in your query. My guess is that you either
have the field name entered incorrectly, or that it is an alias. Can you
post the entire SQL string?

Dale
--
Email address is not valid.
Please reply to newsgroup only.


Bob said:
Ok thank Ofer I did just what you suggested I still get a popup box saying
"Enter Paramater Value" Net_Tot_PaY_USD then there is a place for input...

I have no idea what I am doing wrong.

Bob


Ofer Cohen said:
First step, replace all null values with 0, or the resault will be Null.

Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)

Second step add the criteria
<> 0

--
Good Luck
BS"D


:

I have a queiry where I have an expression.

USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]

I would like to have a criteria that basicly selects all records that are
greater than or less than 0..

I have tried various things and nothing seems to work.. When I put even a
simple criteria like =2 the querie as for paramaters to be supplied.

What am I doing wrong...

Thanks

Bob
Click to expand...
Click to expand...
Click to expand...
 
O

Ofer Cohen

Sorry, should be

Select C , C + D as F From QueryName

--
Good Luck
BS"D


Bob said:
Hi Dale the name is the name of and expression in the same query... How do I
get around that one..

Bob and thanks



Dale Fye said:
Bob,

This message (prompt) indicates that there is a field [Net_Tot_Pay_USD]
(looks like the first field in the sequence below) that does not actually
exist in one of the tables used in your query. My guess is that you either
have the field name entered incorrectly, or that it is an alias. Can you
post the entire SQL string?

Dale
--
Email address is not valid.
Please reply to newsgroup only.


Bob said:
Ok thank Ofer I did just what you suggested I still get a popup box saying
"Enter Paramater Value" Net_Tot_PaY_USD then there is a place for input...

I have no idea what I am doing wrong.

Bob


:

First step, replace all null values with 0, or the resault will be Null.

Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)

Second step add the criteria
<> 0

--
Good Luck
BS"D


:

I have a queiry where I have an expression.

USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]

I would like to have a criteria that basicly selects all records that are
greater than or less than 0..

I have tried various things and nothing seems to work.. When I put even a
simple criteria like =2 the querie as for paramaters to be supplied.

What am I doing wrong...

Thanks

Bob
Click to expand...
Click to expand...
Click to expand...
 
O

Ofer Cohen

Would be helpfull if you post the full SQL.

If you have SQL such as

Select [A]+ As C , [C]+[D] As [F] From TableName

You'll be prompt with [C]
In that case change the SQL to

Select [A]+ As C , [A]++[D] As [F] From TableName

Or create one query that sum A and B
Select [A]+ As C From TableName

And then create a second query based on the first one, and then you can use
C as a field.
Select C , C + D as F From TableName

--
Good Luck
BS"D


Bob said:
Hi Dale the name is the name of and expression in the same query... How do I
get around that one..

Bob and thanks



Dale Fye said:
Bob,

This message (prompt) indicates that there is a field [Net_Tot_Pay_USD]
(looks like the first field in the sequence below) that does not actually
exist in one of the tables used in your query. My guess is that you either
have the field name entered incorrectly, or that it is an alias. Can you
post the entire SQL string?

Dale
--
Email address is not valid.
Please reply to newsgroup only.


Bob said:
Ok thank Ofer I did just what you suggested I still get a popup box saying
"Enter Paramater Value" Net_Tot_PaY_USD then there is a place for input...

I have no idea what I am doing wrong.

Bob


:

First step, replace all null values with 0, or the resault will be Null.

Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)

Second step add the criteria
<> 0

--
Good Luck
BS"D


:

I have a queiry where I have an expression.

USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]

I would like to have a criteria that basicly selects all records that are
greater than or less than 0..

I have tried various things and nothing seems to work.. When I put even a
simple criteria like =2 the querie as for paramaters to be supplied.

What am I doing wrong...

Thanks

Bob
Click to expand...
Click to expand...
Click to expand...
 
D

Dale Fye

Bob,

What does the expression look like?

If Ofer's suggestion doesn't do it, then post your entire SQL string and
we'll take a look.

Dale

Bob said:
Hi Dale the name is the name of and expression in the same query... How
do I
get around that one..

Bob and thanks



Dale Fye said:
Bob,

This message (prompt) indicates that there is a field [Net_Tot_Pay_USD]
(looks like the first field in the sequence below) that does not actually
exist in one of the tables used in your query. My guess is that you
either
have the field name entered incorrectly, or that it is an alias. Can you
post the entire SQL string?

Dale
--
Email address is not valid.
Please reply to newsgroup only.


Bob said:
Ok thank Ofer I did just what you suggested I still get a popup box
saying
"Enter Paramater Value" Net_Tot_PaY_USD then there is a place for
input...

I have no idea what I am doing wrong.

Bob


:

First step, replace all null values with 0, or the resault will be
Null.

Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)

Second step add the criteria
<> 0

--
Good Luck
BS"D


:

I have a queiry where I have an expression.

USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]

I would like to have a criteria that basicly selects all records
that are
greater than or less than 0..

I have tried various things and nothing seems to work.. When I put
even a
simple criteria like =2 the querie as for paramaters to be
supplied.

What am I doing wrong...

Thanks

Bob
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Espresions in criteria 2
Data logic/brain cramp 0
query criteria eliminates too many record results 1
Automatically change query criteria 5
Less then and greater then operators in iif criteria expression 7
Parameter/Criteria settings for percentage expression field 2
Using 2 form fields as one criterium 8
MANY 'or' criteria 1

Top