Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / August 2006

Tip: Looking for answers? Try searching our database.

Filter out files that are blank?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Janet - 11 Aug 2006 17:19 GMT
I've read and tried queries, sorts, reports, articles, posts, etc., but still
can't figure out how to run a report that will leave off the records that are
blank in one field.

Example:  I have 1 field that may have a date entered.  If it's blank, I do
not want it to print on the report.

I've tried all types of processes, but can't make it work.

Any ideas?
Janet
Rick B - 11 Aug 2006 17:33 GMT
Just base your report on a query.

In the criteria under that date field put...

Is Not Null

Signature

Rick B

> I've read and tried queries, sorts, reports, articles, posts, etc., but
> still
[quoted text clipped - 10 lines]
> Any ideas?
> Janet
Janet - 11 Aug 2006 17:55 GMT
Worked like a charm.

Thanks,Janet

> Just base your report on a query.
>
[quoted text clipped - 16 lines]
> > Any ideas?
> > Janet
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
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.