Dear Scott,

I tried attaching the front and back end of my database and I got the following message, "Your submission could not be processed because a security token was missing.
If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error." I think the database exceeds the file size to be attached.

Silvia

I've tried using the criteria equation, >=[Forms]![District Report Subform by Date and Health Score]![txtlowscore] And <=[Forms]![Report Subform by Date and Health Score]![txthighscore], but it did not work. I also tried using Between [Forms]![District Report Subform by Date and Health Score]![txtlowscore] And [Forms]![Report Subform by Date and Health Score]![txthighscore]. This also did not work. When I try entering the score range with either one for a range of 0 to 20 I get values anywhere from 0 to 100 which is outside the range I'm looking for.

I'm out of nails to bite. :-(

Did you try zipping the files together? Make sure you do a compact and repair first. Also you may need to strip out all but the objects I need to test with.

Scott,

I did the compact and repair. The combined files are of size 7.73 MB and the forum only allows 97.7 KB.

I don't know how to strip the database of everything but the objects. Not sure what that means.

Scott,

I stripped the query to just the scores and dates and ran the query with the aforementioned code. The date seems to be working but the score range does not work.
The weird part that I noticed is that the range works except when it comes to the value of 100. The data set ranges in values from 0 to 100. No matter what range I search for whatever reason the values of 100 keep showing up. Very puzzling.

Quote:

---

Originally Posted by SilviaReynoso

Scott,

I stripped the query to just the scores and dates and ran the query with the aforementioned code. The date seems to be working but the score range does not work.
The weird part that I noticed is that the range works except when it comes to the value of 100. The data set ranges in values from 0 to 100. No matter what range I search for whatever reason the values of 100 keep showing up. Very puzzling.

---

If its only records that have a score of 100, then check those records and make sure they were entered as numbers. One other thing to try, this is odd, but try putting two hidden controls on the form with a controlsource of:

=CINT([txtHigh]) and =CINT([txtLow])

then reference those two controls instead of the others.