filter blank fields

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / May 2005

filter blank fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rmeyer@puliz.com - 07 May 2005 00:20 GMT

I want a query to filter in only the fields that have nothing in them in a
specific field. How can I do that without making it numerical. I tried
=""

Reply to this Message

jl5000 - 07 May 2005 02:00 GMT

Try this in your query's criteria

Is Null

Signature

jl5000
<a href="http://joshdev.com"></a>

> I want a query to filter in only the fields that have nothing in them in a
> specific field. How can I do that without making it numerical. I tried
> =""

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.