A
Andrew Tatum
So, I was 95% done with this form. I then went back and tried it
again... this time the wiered thing happened.
I have a qRateLess and qRateLast field. It's like "Choose the minimum
or maximum"
The Min/Max fields on the form have the EXACT same properties. However,
when I put something in the Minimum field... it goes blank claiming
there are no records. However, if I pust put something in the maximum
field... it comes up with a ton of stuff.
Here is the query that the form hits:
Between (NZ([Forms]![Message Report Query Center]![qRateLess],0)) And
(NZ([Forms]![Message Report Query Center]![qRateLast],10000000000))
I believe it's correct. I have qRateLess to be set to 0 if blank and
qRateLast to be set to a really high number is blank.
Any ideas what could be causing the chaos here? It's driving me insane!
again... this time the wiered thing happened.
I have a qRateLess and qRateLast field. It's like "Choose the minimum
or maximum"
The Min/Max fields on the form have the EXACT same properties. However,
when I put something in the Minimum field... it goes blank claiming
there are no records. However, if I pust put something in the maximum
field... it comes up with a ton of stuff.
Here is the query that the form hits:
Between (NZ([Forms]![Message Report Query Center]![qRateLess],0)) And
(NZ([Forms]![Message Report Query Center]![qRateLast],10000000000))
I believe it's correct. I have qRateLess to be set to 0 if blank and
qRateLast to be set to a really high number is blank.
Any ideas what could be causing the chaos here? It's driving me insane!