MS Access Form Filter
$5-10 USD
Paiement à la livraison
Table TPNs has a text field [Test Number]. The data (when it exists) is in the form TPN-nnnna. My form should show only records with Test Number having a value of TPN-something.
The property of the form is:
Record Source: TPNs
Filter: ((TPNs.[Test Number] Is Not Null))
The problem is all the records with a blank Test Number appear. What am I doing wrong?
It is possible that the field contains white space so I tried filtering by TPNs.[Test Number] Is T* but that raised an error. Also tried TPNs.[Test Number]=T* How can I put an expression in the filter? The attached zip file is 900 KB. The form is called "Test procedures".
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
## Platform
MS Access 97
## Deadline information
Need the answer as soon as possible.
Nº du projet : #2881960