Basic filter for Query newbie

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Widemonk - 20 May 2005 14:31 GMT

I want to generate a report but filter out some records, depending on the
value of a certain field. From what I can gather reading the posts in the
Reports section, I need to do it from a Query but have no idea how.

This field simply has 1 character in it... and A, B or C etc.

For instance, I want my report to show all records except those that are set
to B, D or F etc

Any help would really be appreciated.

Reply to this Message

Ofer - 20 May 2005 14:50 GMT

To include all the records except b,d,f then tha query will include the
filter not in (a)

Select * From MyTable Where MyField not in ("B","D","F")

If you want the query to return the records that are equal to the value you
want you will write it that way

Select * From MyTable Where MyField in ("A","C","E")

> I want to generate a report but filter out some records, depending on the
> value of a certain field. From what I can gather reading the posts in the
[quoted text clipped - 6 lines]
>
> Any help would really be appreciated.

Reply to this Message

Widemonk - 20 May 2005 15:07 GMT

Ah... finally.

Thanks very much :)

> To include all the records except b,d,f then tha query will include the
> filter not in (a)
[quoted text clipped - 16 lines]
> >
> > Any help would really be appreciated.

Reply to this Message

Ofer - 20 May 2005 15:28 GMT

any time, have a good weekend

> Ah... finally.
>
[quoted text clipped - 20 lines]
> > >
> > > Any help would really be appreciated.

Reply to this Message