LAazsx
03-25-2011, 10:31 PM
Hi, is it possible to filter the results returned when a form reads a table? I have a textbox which reads the sum of the whole column.
My form is reading the table like the query
SELECT * FROM tablename;
and my textbox is like
SELECT SUM(Debit) FROM tablename;
but what i what it to do is to read specific entries only.
SELECT * FROM tablename WHERE AccountName = 'Cash';
and
SELECT SUM(Debit) FROM tablename WHERE AccountName = 'Cash';;
My form is reading the table like the query
SELECT * FROM tablename;
and my textbox is like
SELECT SUM(Debit) FROM tablename;
but what i what it to do is to read specific entries only.
SELECT * FROM tablename WHERE AccountName = 'Cash';
and
SELECT SUM(Debit) FROM tablename WHERE AccountName = 'Cash';;