Query Drop box, etc Help will pay for your time!!

[Rated R1]

I wrote this before in the NGs, so I am going to paste the responses that I got
and see if someone can please help me. Email me and we can set something up as
Id even be willing to pay for your time to get me to learn this procedure:

MY ORIGINAL POST:
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..

THEN A RESPONSE:
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.

THEN I WROTE:
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

THEN I GOT THIS
read this, it solves your problem: http://www.mvps.org/access/forms/frm0028.htm

SO MY FINAL RESPONSE WAS:
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

If anyone can help me PLEASE email me and we can talk. I need this for work as
soon as possible, thanks in advance,
Scott

[MacDermott]

Let's go back to your statement that you don't understand 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"

Could you list the terms in this statement which you don't understand?

- Turtle

"Rated R1" <ra*****@aol.co m> wrote in message
news:20******** *************** ****@mb-m22.aol.com...

I wrote this before in the NGs, so I am going to paste the responses that I got and see if someone can please help me. Email me and we can set something up as Id even be willing to pay for your time to get me to learn this procedure:

MY ORIGINAL POST:
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..

THEN A RESPONSE:
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.

THEN I WROTE:
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

THEN I GOT THIS
read this, it solves your problem: http://www.mvps.org/access/forms/frm0028.htm
SO MY FINAL RESPONSE WAS:
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

If anyone can help me PLEASE email me and we can talk. I need this for work as soon as possible, thanks in advance,
Scott

[Rated R1]

actually after spending a few mins on it today...THAT sentence I understand as
far as the concept...but how to actually do it is still another story

[MacDermott]

Sounds like progress already.

Can you build a query for the first combobox?


"Rated R1" <ra*****@aol.co m> wrote in message
news:20******** *************** ****@mb-m15.aol.com...

actually after spending a few mins on it today...THAT sentence I understand as far as the concept...but how to actually do it is still another story

[Rated R1]

well my query right now in my first combo/dropdown box (i created in a form),
is just the column style (but I put distinct in there, so that it doesnt
replicate the 100 of the same style names), I can make the same for every one
if I had to, but its connecting them so that one creates an afterevent or
something of just listing the others. And then at the end spitting out a
result. Is tere a way we can talk via email as well since I cant really check
the NGs during the work week

[MacDermott]

I've sent a reply to the address you're using in the newsgroup; if that's
not where you'd like to correspond, please post your correct e-mail.

- Turtle

"Rated R1" <ra*****@aol.co m> wrote in message
news:20******** *************** ****@mb-m11.aol.com...

well my query right now in my first combo/dropdown box (i created in a form), is just the column style (but I put distinct in there, so that it doesnt
replicate the 100 of the same style names), I can make the same for every one if I had to, but its connecting them so that one creates an afterevent or
something of just listing the others. And then at the end spitting out a
result. Is tere a way we can talk via email as well since I cant really check the NGs during the work week