By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Query, drop box HEELLP!

P: n/a
PLEASE HELP!!
I am trying to create a database for my small business. I have typed a bunch
of information in a table in 5 columns (style, mm, karat, quantity, labor
cost). We have different labor costs obviously depending on what combination
those first 4 factors are for example respectively in the columns mentioned
above
(abc, 5mm, 14karat, 10pieces), would be $5 for the labor cost. What I want to
be able to do is produce a query (pref drop down or similar), that would take
what I chose from the style, mm, karat, and quantity, and display the resulting
labor cost. In the one above the labor cost would be $5, however if I changed
say just the karat to 18karat, the labor would display $6. Any help would be
GREATLY appreciated if you can email me it might be easier. If you think youd
need to see what I have typed so far please email me and I can send what I have
so far..
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
ra*****@aol.com (Rated R1) wrote in
news:20***************************@mb-m06.aol.com:
PLEASE HELP!!
I am trying to create a database for my small business. I have typed a
bunch of information in a table in 5 columns (style, mm, karat,
quantity, labor cost). We have different labor costs obviously
depending on what combination those first 4 factors are for example
respectively in the columns mentioned above
(abc, 5mm, 14karat, 10pieces), would be $5 for the labor cost. What I
want to be able to do is produce a query (pref drop down or similar),
that would take what I chose from the style, mm, karat, and quantity,
and display the resulting labor cost. In the one above the labor cost
would be $5, however if I changed say just the karat to 18karat, the
labor would display $6. Any help would be GREATLY appreciated if you
can email me it might be easier. If you think youd need to see what I
have typed so far please email me and I can send what I have so far..


If I were doing this I would

Create a laborcost Table
with 4 fields
style, mm, karat, laborcost (and probably a laborcostId field from habit)

In that table I would create one record for each possible combination of
factors.

My first record might be
abc,5,14,10.

In my query I would JOIN my main table to the laborcost table ON
maintable.style = laborcost.style AND
maintable.mm = laborcost.mm AND
maintable.karat = laborcost.karat

and SELECT maintable.* (or whatever),
laborcost.laborcost

I would remove laborcost from my main table as it is now redundant.

This is assuming I started from the situation as you describe it.

Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.
Nov 13 '05 #2

P: n/a
sorry, but I am database-illiterate. If I send you the table that I have
written, can you just write maybe 1 or 2 lines (obviously not it all), just to
show me what you mean?
Nov 13 '05 #3

P: n/a
Access already contains a tool which may do all you need.
Open your table.
From the menu, select Records - Filter - Filter by Form.
The table will change to a single record, with drop boxes for each field.
Fill in the fields, and click Filter - Apply Filter.
Your table will now show only the records which match your entries.

You can use Records - Remove Filter/Sort to return to your full table.

HTH
- Turtle

"Rated R1" <ra*****@aol.com> wrote in message
news:20***************************@mb-m06.aol.com...
PLEASE HELP!!
I am trying to create a database for my small business. I have typed a bunch of information in a table in 5 columns (style, mm, karat, quantity, labor
cost). We have different labor costs obviously depending on what combination those first 4 factors are for example respectively in the columns mentioned above
(abc, 5mm, 14karat, 10pieces), would be $5 for the labor cost. What I want to be able to do is produce a query (pref drop down or similar), that would take what I chose from the style, mm, karat, and quantity, and display the resulting labor cost. In the one above the labor cost would be $5, however if I changed say just the karat to 18karat, the labor would display $6. Any help would be GREATLY appreciated if you can email me it might be easier. If you think youd need to see what I have typed so far please email me and I can send what I have so far..

Nov 13 '05 #4

P: n/a
Yes this is similar to what I want to do...however with a few differences.
First off in the first column I will choose "style a", i want the next column
to only give me the results that fall within that category. Then from those
choices I select for example "4mm", then I want the third colum to give only
the choices that fall within the "style a" + "4mm" category. Then in that
column I choose "14karat", then in the 4th I want only those that fall within
"style a" + "4mm" + "14karat", and so on until the 5th column when there will
be the result
Audio and Video Trading Lists: members.aol.com/ratedr1/homepage.html
"Marge, You Know That Trying is the First Step Towards Failure!!"
"Ohhh...they have the Internet on Computers Now??
"Damn You Rockem Sockem Robots..Cant We All Just Get Along?" -Homer
Nov 13 '05 #5

P: n/a
read this, it solves your problem:
http://www.mvps.org/access/forms/frm0028.htm
Nov 13 '05 #6

P: n/a

I will pay someone a reasonable price for leading me to the ulimate answer and
helping me learn access for this result

thank you so much for leading me to that page...it will be of great help in the
future, however. The problem is on my computer it came up in Chinese. Wel
actually it looked like English, but when I read the words out loud it sounded
like Chinese to me :-) For example..in this line :
To filter records in a combo/listbox based on the value selected in another
combo/listbox, you can use a stored query which uses the first control's value
as a parameter
One of the problems is, since I am not database literate, I would need to learn
how to do this from the beginning. All that I have typed out is the table with
the 5 columns (and even then I found out I need a primary key for some reason
which I didnt have). I haent written a query for any of the columns yet, so I
cant even get to the point of the page that you have shown me. Is there any
further help that you could provide me? (or if I send you the database can you
write one quick query for me to show me?). I really want to get this done, and
once I learn how to do something, I never forget it (I can build comps, design
whole networks, mastered all the other MS programs, most of that other simple
stuff to professionals, but stuff that 99% of the others cant do), so I know
when I learn databases, I can take it to the next level myself.
Thanks in advance for any help possible.
Scott

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.