parameter query

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

Guest

Have a parameter query that says Between [Type beginning#]
and [Type Ending#]. However results are not what is
typed. If I type between 1 & 10, it just shows records 1
& 10 nothing between. If I type between 1 & 50, it shows
records 1-5 skips to 10 then has records 10-50. Checked
the format of field, everything looks OK. Any help would
be appreciated... Thank you.
 
Have a parameter query that says Between [Type beginning#]
and [Type Ending#]. However results are not what is
typed. If I type between 1 & 10, it just shows records 1
& 10 nothing between. If I type between 1 & 50, it shows
records 1-5 skips to 10 then has records 10-50. Checked
the format of field, everything looks OK. Any help would
be appreciated... Thank you.
Click to expand...

Looks like the fields' datatype is Text. Try changing into Numeric.
 
The field is numeric. Don't understand when I type
Between 1 & 50, it shows me those records. Also this
field contains an expression. Is there something special
you need to do for a parameter query with an expression in
the field. Thanks.
-----Original Message-----
[email protected] said:
Have a parameter query that says Between [Type beginning#]
and [Type Ending#]. However results are not what is
typed. If I type between 1 & 10, it just shows records 1
& 10 nothing between. If I type between 1 & 50, it shows
records 1-5 skips to 10 then has records 10-50. Checked
the format of field, everything looks OK. Any help would
be appreciated... Thank you.
Click to expand...

Looks like the fields' datatype is Text. Try changing into Numeric.

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

.
Click to expand...
 
The field is numeric. Don't understand when I type
Between 1 & 50, it shows me those records. Also this
field contains an expression. Is there something special
you need to do for a parameter query with an expression in
the field. Thanks.
Click to expand...

Just a minute... are you literally typing 'between 1 & 50' ? Amazing
that works. The syntax is 'between 1 and 50'
 
Back
Top