D
Doug
I have a table with a numeric ID and a text field. I want to write a query
where I can select a range of numeric ID's, but I'd like the user to see just
the text fields.
EG 1=buiding block
2=1 hectare
3=2 hectare
4=small farm
5=farm
6=rural land
To query a property table, which stores only the 1 to 6 number, I'd like the
parameter entry for the query to be a comb or list box for the "between [low
combo] and [high combo] and use the numerics in the selection criteria.
where I can select a range of numeric ID's, but I'd like the user to see just
the text fields.
EG 1=buiding block
2=1 hectare
3=2 hectare
4=small farm
5=farm
6=rural land
To query a property table, which stores only the 1 to 6 number, I'd like the
parameter entry for the query to be a comb or list box for the "between [low
combo] and [high combo] and use the numerics in the selection criteria.