Search results

  1. C

    Runtime Error 6: Overflow problem

    Hey everyone, I know this problem has come up on the forums and I have read the threads to see if they will help me solve my problem but I cannot get the problem fixed. I am trying to get a profit margin percentage by doing a Davg of the two fields I need from a query I have. Here is the...
  2. C

    DSum running total problem

    Hey everyone, I have a query that I am using to try to get the running total of a person's sales over a year for multiple years. The query has four fields: SALES_PERSON_ID (AUTONUMBER), EMPL_LAST_NAME, TOTAL_SALES, PERIOD_ENDING_DATE. I have added the last field as the running total with the...
  3. C

    Getting Dates in Combo box in calendar order

    Hey everyone, I have a combobox that lists the months in a year. They are being pulled from a query and are formatted like January, February, etc. The problem is that they are being listed in alphabetical order and I want them to be listed in chronological order as they are in a calendar...
  4. C

    Autopopulating problems.

    Hey everyone, I have a form that when I select choices from a combobox it autopopulates textboxes with the information. All of that works great. What I am having a problem with is that I would like to put N/A in the text boxes when there is no information to put in the text box. Here is a...
  5. C

    Using DSum to calculate YTD

    Hey everyone, I am trying to calculate YTD in a form using the selection made from a combobox . When I select Year, Month, and Sales Person from three comboboxes it auto populates text boxes. All this works, the problem is I cannot figure out how to get the year to date for the year that I...
  6. C

    Help Calculating YTD

    Hey everybody, I am trying to calculate YTD sales and I was wondering if anybody has any ideas on how to do this. Here is the SQL for the query that I have right now: SELECT [TOTAL SALES].EMPL_LAST_NAME, [TOTAL SALES].metMonth, [TOTAL SALES].metYear, Sum([TOTAL SALES].TOTAL_SALES) AS...
  7. C

    Autopopulating Text Boxes (Help!)

    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...
  8. C

    Question Cascading Combo Box

    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...
Back
Top Bottom