Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty data are automatically filtered in Queries
Message
De
10/05/2002 13:59:12
Jason Dalio
Northern Interior Regional Health Board
Prince George, Colombie Britannique, Canada
 
 
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Divers
Thread ID:
00654161
Message ID:
00655193
Vues:
26
This message has been marked as the solution to the initial question of the thread.
In SQL server let's say you actually see in the field. In Access the only way to tell is to run a query with a criteria of Is Null or = "". I did verify that your fields are "". A work around would be to use CStr([FieldName] & "") in your query to convert the NULLs to zero-length strings. These you can compare on.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform