date criteria problem

R

rs0905

I am trying to create a query that looks for date values that are greater
than or equal to a date value on an open form:
=[forms]![counselorreportmenu]![txtbegin]
Click to expand...

This isn't working. The field on the form is a date format field. What can
I do to get this to work? I had a similar problem in code on a form where I
was trying to find dates greater than a string date value. Wondering if it
is a formatting issue on the returned value...?

Thanks in advance!
 
R

rs0905

NEVERMIND!

I just used DateValue and now it's working. Thanks anyway!

rs0905 said:
I am trying to create a query that looks for date values that are greater
than or equal to a date value on an open form:
=[forms]![counselorreportmenu]![txtbegin]
Click to expand...

This isn't working. The field on the form is a date format field. What can
I do to get this to work? I had a similar problem in code on a form where I
was trying to find dates greater than a string date value. Wondering if it
is a formatting issue on the returned value...?

Thanks in advance!
Click to expand...
 
R

Ryan Tisserand

Here was my solution. I placed this code into the query grid under the
field StartDateFilter:Date1
=IIf(IsNull([Forms]![C25]![StartDateFilter]),[Date1],[Forms]![C25]![StartDateFilter])
Click to expand...


rs0905 said:
I am trying to create a query that looks for date values that are greater
than or equal to a date value on an open form:
=[forms]![counselorreportmenu]![txtbegin]
Click to expand...

This isn't working. The field on the form is a date format field. What can
I do to get this to work? I had a similar problem in code on a form where I
was trying to find dates greater than a string date value. Wondering if it
is a formatting issue on the returned value...?

Thanks in advance!
Click to expand...
 
Top