search query

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

Guest

okay, i have a search query that when I enter a parameter it will give me a report. but the problem is that it will only produce what I have entered exactely. what i want is if i search for 2002 i get results back like 2002, 2003, or 2004, 2002. I want it to list everything if it is in that field, not if just one item is there.
 
If you ask it to give you results from 2002, it will only give you 2002.
That is working as designed.

If you want results greater than 2002, then you need to tell it that. You
need to use >2002 as your criteria. Without more details, it would be hard
to give you a better answer.

Please give us more details if this does not answer your questions.

Rick


okay, i have a search query that when I enter a parameter it will give me a
report. but the problem is that it will only produce what I have entered
exactely. what i want is if i search for 2002 i get results back like 2002,
2003, or 2004, 2002. I want it to list everything if it is in that field,
not if just one item is there.
 
Have you tried using the Between.... AND .. syntax? That
is, Between 2001 and 2004? This will include the date
range you are looking for, it should work.
Good luck
-----Original Message-----
okay, i have a search query that when I enter a
Click to expand...
parameter it will give me a report. but the problem is
that it will only produce what I have entered exactely.
what i want is if i search for 2002 i get results back
like 2002, 2003, or 2004, 2002. I want it to list
everything if it is in that field, not if just one item
is there.
 
Back
Top