Correct syntax for Criteria in Design View

[Kurt]

I have several fields in an Access database.

I want to display just records greater than 0.

For one field I have the following:

Field: PYTD_GP
Table
Total: Where
Criteria: Abs([PYTD_GP])
[PYTD_GP]>0

Is this the correct syntax?

Thanks for any and all help.

 

[Joe4]

If you put the Criteria in the Criteria box under the field itself, you do not need to explicitly reference that field name again. Just use:

> 0

 

[Kurt]

If you put the Criteria in the Criteria box under the field itself, you do not need to explicitly reference that field name again. Just use:

> 0

That is the next thing I tried after I posted this message and yes it works.

Smitty also showed this to me yesterday!

Have a great weekend!

Thanks!