If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sorting
I have a product field tied to a combo box that I need to sort by the
amount used for that client each use is in the sample table im thinking that i need to set up a qeury for this first then filter but how do you sort by number of uses the most used coming up first and so on |
#2
|
|||
|
|||
Gregory,
You are correct, it would be a good idea to use a query which you can use as the Row Source of your Combobox, and sort the records in the query according to the AmountUsed field. If you need more specific help, please post back with more details of your data, maybe with examples, and explanation of your desired outcome. -- Steve Schapel, Microsoft Access MVP GREGORY HICKMOTT wrote: I have a product field tied to a combo box that I need to sort by the amount used for that client each use is in the sample table im thinking that i need to set up a qeury for this first then filter but how do you sort by number of uses the most used coming up first and so on |
#3
|
|||
|
|||
I got the query working by putting my [procedures] [sample] [case] [client]
tables in a query and count procedur id this query into a second query and adding second procedures table, If filter the first query by client name I get the resault I was looking for.How do I pass the fiter to the first query. first query name is [procedurespersamplebyclentsub] the final is [procedurespersamplebyclent] I can use the query in a combobox but I can't send the filter to the query whitch is set by another combo box in a parent form. "Steve Schapel" wrote in message ... Gregory, You are correct, it would be a good idea to use a query which you can use as the Row Source of your Combobox, and sort the records in the query according to the AmountUsed field. If you need more specific help, please post back with more details of your data, maybe with examples, and explanation of your desired outcome. -- Steve Schapel, Microsoft Access MVP GREGORY HICKMOTT wrote: I have a product field tied to a combo box that I need to sort by the amount used for that client each use is in the sample table im thinking that i need to set up a qeury for this first then filter but how do you sort by number of uses the most used coming up first and so on |
#4
|
|||
|
|||
Gregory,
If I understand you correctly, you can refer to the combobox on the parent form in the criteria of the applicable field in your query, using syntax such as [Forms]![NameOfYourParentForm]![NameOfCombobox] -- Steve Schapel, Microsoft Access MVP GREGORY HICKMOTT wrote: I got the query working by putting my [procedures] [sample] [case] [client] tables in a query and count procedur id this query into a second query and adding second procedures table, If filter the first query by client name I get the resault I was looking for.How do I pass the fiter to the first query. first query name is [procedurespersamplebyclentsub] the final is [procedurespersamplebyclent] I can use the query in a combobox but I can't send the filter to the query whitch is set by another combo box in a parent form. |
#5
|
|||
|
|||
steve schaple
Form the afterupdate of the parent combo box I can change the rowsource and with the filter But I need to alter the first query before I can call the second Number 1 Child16!ProceduresName.RowSource = "SELECT [procedurespersamplebyclientsub].[ProceduresId], [procedurespersamplebyclientsub].[ProceduresName] FROM [procedurespersamplebyclientsub] WHERE [procedurespersamplebyclientsub].[clientID] = -1606758480;" number2 Child16!ProceduresName.RowSource = "SELECT [procedurespersamplebyclient].[ProceduresId], [procedurespersamplebyclient].[ProceduresName] FROM [procedurespersamplebyclient];" do I need to use a third combo box just to send the filter to the first query and hide so the usr does not see it "Steve Schapel" wrote in message ... Gregory, If I understand you correctly, you can refer to the combobox on the parent form in the criteria of the applicable field in your query, using syntax such as [Forms]![NameOfYourParentForm]![NameOfCombobox] -- Steve Schapel, Microsoft Access MVP GREGORY HICKMOTT wrote: I got the query working by putting my [procedures] [sample] [case] [client] tables in a query and count procedur id this query into a second query and adding second procedures table, If filter the first query by client name I get the resault I was looking for.How do I pass the fiter to the first query. first query name is [procedurespersamplebyclentsub] the final is [procedurespersamplebyclent] I can use the query in a combobox but I can't send the filter to the query whitch is set by another combo box in a parent form. |
#6
|
|||
|
|||
Gregory,
I am very sorry, I am completely lost here. What is the meaning of your Number 1 and Number 2? Both of these refer to the same combobox, don't they? Why are you changing the Row Source of the same combobox twice? What is happening between the two events? What is supposed to trigger these two adjustments to the Row Source? Are you able to describe the whole procedure from beginning to end, of what you are trying to achieve? -- Steve Schapel, Microsoft Access MVP GREGORY HICKMOTT wrote: steve schaple Form the afterupdate of the parent combo box I can change the rowsource and with the filter But I need to alter the first query before I can call the second Number 1 Child16!ProceduresName.RowSource = "SELECT [procedurespersamplebyclientsub].[ProceduresId], [procedurespersamplebyclientsub].[ProceduresName] FROM [procedurespersamplebyclientsub] WHERE [procedurespersamplebyclientsub].[clientID] = -1606758480;" number2 Child16!ProceduresName.RowSource = "SELECT [procedurespersamplebyclient].[ProceduresId], [procedurespersamplebyclient].[ProceduresName] FROM [procedurespersamplebyclient];" do I need to use a third combo box just to send the filter to the first query and hide so the usr does not see it |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting Columns | Mike | Worksheet Functions | 3 | August 4th, 2004 03:20 AM |
Sorting blank and non blank column of data | Hari | General Discussion | 1 | July 23rd, 2004 12:13 AM |
triple sorting and twice sum | nowfal | General Discussion | 1 | July 16th, 2004 09:53 PM |
Count Unique Values with sorting and filtering by pop-up form | Yanick | Setting Up & Running Reports | 8 | June 4th, 2004 12:51 PM |
Sorting numbers | Lady Layla | Setting up and Configuration | 0 | April 5th, 2004 06:16 PM |