removing record in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following query set up

Field1: Customer Name
Field2:PriceError:count(IIF(priceError)=-1,"")
Field2:CoachError:count(IIF(coacherror)=-1"")
Field3:Between [Start Date: ] and [End Date: ]

What I'd like to have happen is, if Price Error or Coach Error is 0, then do
not show the record at all. I've tried several things and cannot get the
record to be removed from the query. Help????
 
In the criteria section of each field write <>0
In SQL it will look like

Select * From TableName Where priceError <> 0 And coacherror <> 0
 
Can you post the SQL you have already?

--
Good Luck
BS"D


Susan said:
I already have criteria in some of the fields such as <>n/a and Between
[Start date] and [End date]. so the end result is counting some wierd
numbers any suggestions?


Ofer Cohen said:
In the criteria section of each field write <>0
In SQL it will look like

Select * From TableName Where priceError <> 0 And coacherror <> 0

--
Good Luck
BS"D


Susan said:
I have the following query set up

Field1: Customer Name
Field2:PriceError:count(IIF(priceError)=-1,"")
Field2:CoachError:count(IIF(coacherror)=-1"")
Field3:Between [Start Date: ] and [End Date: ]

What I'd like to have happen is, if Price Error or Coach Error is 0, then do
not show the record at all. I've tried several things and cannot get the
record to be removed from the query. Help????
Click to expand...
Click to expand...
Click to expand...
 
I already have criteria in some of the fields such as <>n/a and Between
[Start date] and [End date]. so the end result is counting some wierd
numbers any suggestions?


Ofer Cohen said:
In the criteria section of each field write <>0
In SQL it will look like

Select * From TableName Where priceError <> 0 And coacherror <> 0

--
Good Luck
BS"D


Susan said:
I have the following query set up

Field1: Customer Name
Field2:PriceError:count(IIF(priceError)=-1,"")
Field2:CoachError:count(IIF(coacherror)=-1"")
Field3:Between [Start Date: ] and [End Date: ]

What I'd like to have happen is, if Price Error or Coach Error is 0, then do
not show the record at all. I've tried several things and cannot get the
record to be removed from the query. Help????
Click to expand...
Click to expand...
 
Back
Top