If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Criteria for check numbers only
Access 2007, Vista SP2 Ultimate
I have a check register in which I enter both the umbers of checks I write and the debit card POS entries. I need to be able to separate out the checks from the debit entries. I have the criteria for the query to separate out the POS transactions in a query: Like 'DBT*' Or Like 'DBT*' But, I am having a hard time figuring out what criteria I need to separate out the check numbers (such as 123, or 371) from the 'DBT' entries in that field for the check number query. Any suggestions would be much appreciated. Jan |
Thread Tools | |
Display Modes | |
|
|