removing record in query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan - 10 Jul 2006 21:25 GMT

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????

Reply to this Message

Ofer Cohen - 10 Jul 2006 21:40 GMT

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

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

Signature

Good Luck
BS"D

> I have the following query set up
>
[quoted text clipped - 6 lines]
> not show the record at all. I've tried several things and cannot get the
> record to be removed from the query. Help????

Reply to this Message

Susan - 10 Jul 2006 22:42 GMT

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?

> In the criteria section of each field write <>0
> In SQL it will look like
[quoted text clipped - 11 lines]
> > not show the record at all. I've tried several things and cannot get the
> > record to be removed from the query. Help????

Reply to this Message