A have a table of volunteers and a table of assignments. I can run a query/report of volunteers who are assigned. How do I create a query of who is not assigned.
Novice
Windows 7 32bit 
Access 2010 32bit
A have a table of volunteers and a table of assignments. I can run a query/report of volunteers who are assigned. How do I create a query of who is not assigned.
Indifferent
Windows 7 32bit Access 2010 32bit
In your query in the criteria for the Assigned Field type IsNull
Populating Null data with Next Available Record
Populating Null Data with Next Available Record
Posting Permissions
Reply With Quote