Query with criteria

[Guest]

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?

 

[jj]

Hi Libby

Try to write between 0 and 0.74

hth
JJ

 

[Guest]

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