Search results

I have this configuration: Table1Debit: ID(auto), Name(text), Amount(number) Table2Credit: ID(auto), Name(text), Amount(number) Query1: SELECT Amount FROM Table1Debit WHERE Name = "John" Query2: SELECT Amount FROM Table1Credit WHERE Name = "John" How can I calculate a balance substracting all...

My problem seems simple, but after hours searching and trying, I gave up. I have 2 tables: Table1: ID(auto), Name(text) Table2: ID(auto), T1ID(number), T1Name(text) I just want to enter a number ID in 'T1ID' and get the corresponding 'Name' from Table1 in field T1Name. I've tried using a...

Hello, hi there.