Search results

Thank you guys for your help. Of course I expected comments about my setup. As I said what I posted here is simply a schematic model. When I propose a problem I try always to use the minimal elements. Sure, I already know that I can use debit and credit in the same record ;-) But my DB is a...

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.