I would appreciate any help with the following Paradox 12 problem.

I need to reference another field value in the same table in my query but don't know the syntax. To keep it simple. Say I have a table named tbl_cost.db with fields cost1 and cost2. I want my query to display only those records where cost1 is greater than cost2. The simple > cost2 in cost1 doesn't work. I have also tried numerous combinations such as below.


| cost1
> tbl_cost.db.cost2

> tbl_cost.db."cost2"

> tbl_cost.db.["cost2"]

> tbl_cost.db.[cost2]

> [tbl_cost.db].[cost2]

> ([tbl_cost.db].[cost2])

> (tbl_cost.db."cost2")

> ([tbl_cost.db].["cost2"])

you have to learn how to use example elements.. same table and/or different table, same concept..

manaually, it's the F5 key.. in code, it's the underscore.. example:

| cost-1 | cost-2|
| _a | > _a |

Thank you. That was just what I needed.