Topic: SQL Query
Hi.
I have a table "Transfers" in a project that uses another table, "Accounts" in a relationship twice as a lookup. So I end up with fields in Transfers of id_Accounts and id_Accounts1. No problem to show all the data in a tablegrid by using two calculated fields. But if I want to do a more detailed search say between two dates I'm unable to use the calculated fields in a SQL Query. So can any one help with a work around.
Thanks
Terry