Search results

when referencing the comboboxes do i need to do Forms![Formname].comboboxname or can i just do the combobox?

I probably should have explained this earlier but this query is the combination of two other queries. One query pulls the data on the total number of quotes a salesperson made and the other is the total number of wins the person has. The two queries are left joined on the salesperson and created...

It can be any day because the date is when the quote is created

It is a Date/Time field

The only reason that it is in this query is so that when I choose the date in cmbDate, only the people who sold in that particluar month of that year are showing in cmbsalesperson

No, when I created the combo box I used the query that I had saved on the navigation pane as the values that I wanted and modified the query to do what I wanted. Do I need to save it on navigation pane?

Here is what the query looks like for the cmbsalesperson combobox: SELECT METRICS.SALES_PERSON, Sum(METRICS.TOTAL_WINS) AS SumOfTOTAL_WINS, Format(Sum(METRICS.MONEY_TOTAL_WINS),"Currency") AS SumOfMONEY_TOTAL_WINS, Sum(METRICS.TOTAL_QUOTES) AS SumOfTOTAL_QUOTES...

The data is already summarized in a query with the number of quotes that the person had for a certain month in all the years that I pulled. What kind of subquery do you think would work. Sorry if this is not a lot of information. I have some knowledge of access but not a lot.

This is the code that I am using to populate the text boxes: Private Sub cmbsalesperson_AfterUpdate() Me.txtwinstotal_month = Me.cmbsalesperson.Column(1) Me.txtwins_month = Me.cmbsalesperson.Column(2) End Sub

Ok here is what I am doing. I have two comboboxes: one is cmbDate and the other is cmbsalesperson. When I choose a date from cmbDate it gives me the sales people who sold in that month of that year in cmbsalesperson. When I choose the saleperson in cmbsalesperson it autopopulates two text...

Sorry I'm confused on what you mean. I put the criteria in the cmbsalesperson query for the control to say that when the Date field in the cmbsalesperson = cmbDate it puts the names of the people who sold in that month in cmbsalesperson. How would I change the filter in this case? Sorry...

This is my first time on the forums, so bear with me. I have a form that has two combo boxes. One is called cmbDate and the other is cmbsalesperson. When I choose the date in cmbDate it filters the names in cmbsalesperson. Now, when I choose a name in cmbsalesperson it autopopulates four...