Using Option Group to select a range of Queries

[Kamitsukenu via AccessMonster.com]

Hi there,

I'm trying to set a form up to select a range of columns in which I'd like to
search for a specific string using presaved queries.

I'm thinking of having 10 text boxes, each displaying a single line of the
received data. I was then going to have to columns of radio buttons to
signify the start and end of the search. The user would then be able to
select 'Start button' 3 and 'end button 5', which, after clicking on the 'go'
button, would run the 'search column 3', 'search column 4' and 'search column
5' queries. If the Start and End value are equal, then you would just run the
relevant search query.

Any ideas how to proceed?

Thanks!

 

[Guest]

With an option group you only get to choose ONE. Instead of option group you
can use multiple checkboxes. In the query add a field in the design view
grid for each check box and on separate criteria row enter -1 (minus one)
and have the other criteria on the same line.

Having to search that many fields for the same thing sounds like a
spreadsheet instead of a normalized relational database.

 

[kamitsukenu via AccessMonster.com]

Hi Karl, thanks for the reply.

I was going to have 2 rows of 10 radio buttons so that I could select a
range; the first being the 'from' point and the second being the 'to' range.
Any tips on how I can set that up?

With an option group you only get to choose ONE. Instead of option group you
can use multiple checkboxes. In the query add a field in the design view
grid for each check box and on separate criteria row enter -1 (minus one)
and have the other criteria on the same line.

Having to search that many fields for the same thing sounds like a
spreadsheet instead of a normalized relational database.

Hi there,

[quoted text clipped - 12 lines]

Thanks!

 

[Guest]

Ido not have a clue how to set up a 'Range of columns' as you described.

Did you try what I suggested?

--
KARL DEWEY
Build a little - Test a little

Hi Karl, thanks for the reply.

I was going to have 2 rows of 10 radio buttons so that I could select a
range; the first being the 'from' point and the second being the 'to' range.
Any tips on how I can set that up?

With an option group you only get to choose ONE. Instead of option group you
can use multiple checkboxes. In the query add a field in the design view
grid for each check box and on separate criteria row enter -1 (minus one)
and have the other criteria on the same line.

Having to search that many fields for the same thing sounds like a
spreadsheet instead of a normalized relational database.

Hi there,

[quoted text clipped - 12 lines]

Thanks!

 

[kamitsukenu via AccessMonster.com]

Hi Karl,

I haven't but I will do later today.

Thanks for your help.

Ido not have a clue how to set up a 'Range of columns' as you described.

Did you try what I suggested?

Hi Karl, thanks for the reply.

[quoted text clipped - 15 lines]