beginner needs help

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am creating a database of store locations with
demographic data for each location. I would like to give
users the ability to do multiple queries against this
data to narrow down a search using different criteria.

I would like the user to have the ability to choose a
field, set a tolerance percentage, and a target value
(i.e. I want to see every store that is within 20% of a
town population of 100,000). Then, I would like to have
the ability to run the same thing, using any field,
against the results of the first query, and so on and so
on.

If anyone has any thoughts on the design and this "drill-
down" query, I would greatly appreciate your thoughts.

Thanks in advance.
 
What you want is certainly possible, but your question is so broad that
answering it would cover a couple of chapters of a book. Much of the answer
depends on the database design.
 
Mike,
You need more help than a newsgroup can provide.
First, buy a book on Access. I loved Using Access by Roger Jennings when I
was starting out, and there are plenty of good authors. Another good one is
Access Developer's Handbook By Litwin,Getz,Gunderloy.

It is much easier to actually do what you want than to give you step by step
instructions.

Broadly, Create an unboud form with just filter criteria
Your filters can be in the form of Text boxes and/or List/combo boxes

The data itself would be displayed in a sub form that is bound to your
table.

Do post back here for more information.

HS
 
I agree with HS. What you want can be done, but it takes a lot of
advanced work. Of course you always teach your users to write queries.
 
Ok, I have done that. I have a list box with the field
names in the table, a text box for tolerance, and a text
box for target value. I have created the subform that is
bound to the table, and currently shows the entire
contents of the table.

This is where I get lost. I would guess that I should
create some type of command button that would execute
something against the subform and filter it so the
subform would only show the results, but I do not know
how to do that. I would also want to then change the
filters and have it apply to the results of the first
filter.

Thank you so much for your help.
 
-----Original Message-----
I am creating a database of store locations with
demographic data for each location. I would like to give
users the ability to do multiple queries against this
data to narrow down a search using different criteria.

I would like the user to have the ability to choose a
field, set a tolerance percentage, and a target value
(i.e. I want to see every store that is within 20% of a
town population of 100,000). Then, I would like to have
the ability to run the same thing, using any field,
against the results of the first query, and so on and so
on.

If anyone has any thoughts on the design and this "drill-
down" query, I would greatly appreciate your thoughts.

Thanks in advance.


.
Click to expand...
 
Woops! Ignore zig and zag on my prev. post reply!

I took a quick look at your request and it seems to me you
could probably try the "Filter by Form" feature already
part of the MS Access program. In Access, while in form
view, click on the icon on your tool bar that has a small
funnel with a form in the background. When you click on
this, it turns all your textboxes into comboboxes. In the
new combo boxes, you can make any variety of selections on
your data to return only the type of data in a set of
forms you wish to see. You can use comparison operators
(<, >, <>, and wildcards, * and ?) to further refine the
data. Next press the icon with just the large funnel to
show only the data you selected.

Denny G.
 
Back
Top