MS Access Form Filter

Terminé Publié le Nov 5, 2002 Paiement à la livraison
Terminé 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.

Administration de Bases de données Ingénierie MySQL PHP Architecture Logicielle Tests de Logiciels SQL

Nº du projet : #2881960

À propos du projet

5 propositions Projet à distance Actif Nov 5, 2002

Décerné à:

agrasth

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 14 jours
(107 Commentaires)
6.2

5 freelances font une offre moyenne de 6 $ pour ce travail

christopherayers

See private message.

$4.25 USD en 14 jours
(47 Commentaires)
4.1
webffiliates

See private message.

$8.5 USD en 14 jours
(19 Commentaires)
3.7
drewdavisvw

See private message.

$8.5 USD en 14 jours
(2 Commentaires)
1.3
estor

See private message.

$3.4 USD en 14 jours
(0 Commentaires)
0.0