Filtering between two values

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

Guest

I am trying to design a macro that allows me to search for a number in a
table, the problem is that the table only lists the start and end numbers for
each record.

e.g. I am searching for ID number 1141755, it is contained in a record with
Start number field of 1141713 and an End number field of 1141790.

If anyone could help please let me know.
 
Tim Few said:
I am trying to design a macro that allows me to search for a number in a
table, the problem is that the table only lists the start and end numbers for
each record.

e.g. I am searching for ID number 1141755, it is contained in a record with
Start number field of 1141713 and an End number field of 1141790.
Click to expand...


You didn't explain how/what this "search" is, but whatever
it is it would use a criteria like:

mynumber Between [Start] And [End]
 
I am trying to write a macro with a box on a form, the idea is that you type
in the number you are searching for, and it checks the table to find which
record contains that number.

Marshall Barton said:
Tim Few said:
I am trying to design a macro that allows me to search for a number in a
table, the problem is that the table only lists the start and end numbers for
each record.

e.g. I am searching for ID number 1141755, it is contained in a record with
Start number field of 1141713 and an End number field of 1141790.
Click to expand...


You didn't explain how/what this "search" is, but whatever
it is it would use a criteria like:

mynumber Between [Start] And [End]
Click to expand...
 
Sorry, I can't help you with macros, they're too limited for
the kinds of things most people need to do. You might be
better off asking in a macros newsgroup.

Regardless of how you want to produce a solution or who can
help you, you will still need to explain what you mean by
"find" a record. Do you want to display it on the same (or
another form) or use the value of one of its fields in a
calculation or what?
--
Marsh
MVP [MS Access]


Tim said:
I am trying to write a macro with a box on a form, the idea is that you type
in the number you are searching for, and it checks the table to find which
record contains that number.

Marshall Barton said:
You didn't explain how/what this "search" is, but whatever
it is it would use a criteria like:

mynumber Between [Start] And [End]
Click to expand...
Click to expand...
 
Back
Top