I have a query in which i have a feild that i want to filter. ie. All people with asthma, all people with HTN and so on. I cannot seem to figure out the coding under that field. I have figured out yes/no fields, and null, but not this new one.
Advanced Beginner
Windows 7 
Access 2007
I have a query in which i have a feild that i want to filter. ie. All people with asthma, all people with HTN and so on. I cannot seem to figure out the coding under that field. I have figured out yes/no fields, and null, but not this new one.
Blessed Bear
Windows 7 Access 2007
It's difficult to gauge exactly what your problem is as we can't see the query but...
Perhaps using the 'LIKE' word might help you in a query.
http://www.techonthenet.com/access/queries/like.php
The link above should help you understand how to use it.
Advanced Beginner
Windows 7 Access 2007
Well the field is a combo box. And I want to seperate out each illness into different queries so i know how many have each different type.
About filters
Posting Permissions
Reply With Quote