Search results

Ok...next question I modified the code to return what I wanted....It returns all records between the dates when there are no nulls present in an entrydate field....however on the impdate field where there are nulls present.... I got it to only return dates between the criteria entered however...

Jal, Thanks for the reply. I did want it to return all records including nulls if no date parameters were entered. I do not want to include nulls if date parameters are included..Just the records in between them. I tried messing around with the code a little but my ideas did not work? Any...

Ok I think I have it working, however it returns the null dates as well as the dates between the criteria I have entered... Don't know if it makes a difference but at one time I changed this field type to text and entered a "" as a default value to the field to get rid of nulls. I have since...

I have enabled all macro options and it still has done nothing... I am sooo confused! Any help anyone can offer would be great Thanks!

It keeps giving me an "undefined function "CheckRange" In expression error Thoughts? Thanks!

Thanks for the reply Wayne. I am very new to this. So I got your function code into a a module and named it CheckRange. I changed the wording in the code to the code below to include the location of the date input boxes. I don't know how to call the function in the query though. Do I simply put...

Forgive me I am a newbie at the whole access thing... but I am trying to design a query using a form that will take user entered values and display a report based on those values. Everything works great except I am having trouble with including null values in the criteria. I want to return all...