Filter from Dewey Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run a report that will only pick up records that fall between
a certain Dewey beginning and ending number. For example, I want all the
records that contail Dewey numbers between 200.000 and 200.215. Can I use the
form filter for this? Do I need script? I'm new to Access. I can plug in
Visual Basic directions, but have no idea how to write a code to do this.
Thank you!
 
Use a query as the record source for your report. In the field of the query
that has the Dewey number' Criteria Row:
Between 200.00 And 200.215

Now, if those numbers were only an example, and the user will select the
numbers, you will need to allow them a way to enter the numbers. The easiest
is to put this in the criteria row and when they run the report, they will
get an input box to enter each number:
Between [Enter Low Number] And [Enter High Number]
 
Back
Top