Query with criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Libby - 12 Sep 2007 20:44 GMT

I am creating a query of training classes whihch includes a field called
grades. I only want to display the grades of below 74%. I thought I would
just type "Between 0 and 74" and it would give me only those people with
those grades. Have I labeled something incorrectly?

Reply to this Message

jj - 12 Sep 2007 20:52 GMT

Hi Libby

Try to write between 0 and 0.74

hth
JJ

>I am creating a query of training classes whihch includes a field called
> grades. I only want to display the grades of below 74%. I thought I would
> just type "Between 0 and 74" and it would give me only those people with
> those grades. Have I labeled something incorrectly?

Reply to this Message

Libby - 12 Sep 2007 21:06 GMT

Thank you so much, I was hoping it was something simple I was missing!

> Hi Libby
>
[quoted text clipped - 6 lines]
> > just type "Between 0 and 74" and it would give me only those people with
> > those grades. Have I labeled something incorrectly?

Reply to this Message