• Registered: 2015-10-13
  • Posts: 38

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

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: SQL Query

Hi Terry,
Because you can't use calculated fields directly in an SQL query, you need to reproduce the calculation in the SQL query itself which should be reasonably straightforward.  Can you attach your project and I'll have a look?
Derek.

  • Registered: 2015-10-13
  • Posts: 38

Re: SQL Query

Hi Derek,
Thanks for the offer but have found another way to get the required outcome. But still would be interesting to know the answer.
Cheers Terry