parameter query

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.
 
B

Bas Cost Budde

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.
 
G

Guest

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...
 
B

Bas Cost Budde

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'
 
Top