Debit Card Purchases

[Jan Il]

Hi all Access 2002 XP - W2K

I have a filter form with a sort format to sort the Debit card purchases.

I now have a field in a table that records both Checks and Debit Card
transactions. I would like to be able to sort between the two types of
transactions to be displayed on a form, using a filter form. Here is the
SQL for the query for the form,

PARAMETERS [Forms]![frmCheckingRecFilter]![TxtDate1] DateTime,
[Forms]![frmCheckingRecFilter]![TxtDate2] DateTime;
SELECT T.BeginBal, T.CheckNo, T.TransactionDate, T.Transaction,
T.CheckDBTAmt, T.DepositAmt, T.TransactionType, T.Comment, (SELECT
SUM(Nz(DepositAmt, 0) - Nz(CheckDBTAmt, 0) + Nz(BeginBal,0))
FROM MyCheckRegister T1
WHERE T1.TransactionDate <= T.TransactionDate) AS RunningBalance
FROM MyCheckRegister AS T
WHERE (((T.TransactionDate) Between
[Forms]![frmCheckingRecFilter]![TxtDate1] And
[Forms]![frmCheckingRecFilter]![TxtDate2])) OR
((([Forms]![frmCheckingRecFilter]![TxtDate1]) Is Null)) OR
((([Forms]![frmCheckingRecFilter]![TxtDate2]) Is Null))
ORDER BY T.CheckNo, T.TransactionDate;

I have created a combo box named cmbDBTExpense on a filter form, to call up
just the DebitCard transactions, and one named cmbCheckNo to call up just
the check numbers. Each has a command button to call up the relative
information in the associated record form.

My problem is, how to separate the two transactions; i.e., Check and DBT
from the same CheckDBT field? I've been working on this for a while, and
trying to use different criteria for the query, but, I'm not having any luck
separating the two transaction types to display as a separate transaction on
the record form. Do I need to use a separate query for each transaction
type using specific criteria? Or...is there a way I can set criteria in the
existing to do any 'either/or' from the filter form control? I'm not sure
on this, and would really appreciate any input on the best course of action.

Is this something that has to be done in the filter form control itself, or
in the code command button?

I would truly appreciate any suggestions or input for this type of process.


Jan
Smiles are meant to be shared,
that's why they're so contagious.