How Do I: Filter OUT a record that is being filtered IN

[RichardAnderson]

I have a database with a table called tblBuilds. Two of the fields are "ProduceByDate"(date) "Completed"(date). I also have a form called frmBuilds_Today. This form has the filer "ProduceByDate=Date()". This filter make only the records with today's date in the "ProduceByDate" field get listed. This is great. But my hangup is when I put a date into the "Completed" field. When the date is put in, I want this record to be ignored by the filter. But I do not know anything really about code.



SO basically, I need the record listed if the "ProduceByDate" is today AND the "Completed" date is empty. Then when a date is added to the Completed field, the record is "filtered out".

The reason I am using a date field for completed is for other forms and reports. So I can filter records by completed date.

[pbaldy]

Try

ProduceByDate=Date() AND Completed Is Null

[RichardAnderson]

Try

ProduceByDate=Date() AND Completed Is Null

Thank you so much .. that worked...

Now for the completed forms... I tried Completed Is >#6/30/2013# and <#8/1/2013# but it gives an error

[pbaldy]

Try

Between #6/30/2013# and #8/1/2013#

[RichardAnderson]

Try

Between #6/30/2013# and #8/1/2013#

Yea, that works but only if I create a query with that criteria for the completed field, then base a form off of that query. I was trying to just type the criteria straight into the filter attribute of the form. BUt nothing worked. I tried...

Completed=Between #6/30/2013# and #8/1/2013#
Completed Is Between #6/30/2013# and #8/1/2013#

IF I have to base the form off a query I will.

[pbaldy]

In a filter probably

Completed Between #6/30/2013# and #8/1/2013#

[RichardAnderson]

Thank you for you help .... Everything is good now...

[pbaldy]

No problem.