Search results

It works if I do that! The only thing is that I have to ask my boss if he wants me to leave them out lol. Thanks for the help everybody!!

I think the problem is that there is zeros in the TOTAL_QUOTE, I didn't know there were. Would this cause the overflow?

I enclosed them in brackets and got: Run-time error '2741': The expression you entered as a query parameter produced this error: '[Profit/TOTAL_QUOTE]'

It is an unbound text box and I'm pretty sure it is the proper type to accept the data , and the code is failing at the ? DAvg("Profit / TOTAL_QUOTE", "MARGIN")

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

The me. is referencing the form that you are using. So say if you had a state and a city combo box, to requery the city box after a state had been selected you would do Requery Me.combocity

Ok, so I have got the query to work by using a subquery seen below: SELECT CHARTDATA2.SALES_PERSON_ID, CHARTDATA2.EMPL_LAST_NAME, CHARTDATA2.JE_PERIOD_ENDING_DATE, CHARTDATA2.metMonth, CHARTDATA2.metYear, CHARTDATA2.TOTAL_SALES, (SELECT Sum(TOTAL_SALES) FROM CHARTDATA2 AS Q WHERE...

Thanks for the help. I really appreciate you taking the time to work with me.

I tried deleting all the data but when I do it erases all the controls that are on the form including the chart

I can't share the database because the relative data is sensitive info but I am using a chart that you can insert while in the design view of the form.

ok it keeps asking for the parameter value of the form controls and i click cancel and pick the choices from the combo boxes but it shows nothing on the chart

This will work but most of the data that I am using is historical data starting from 01/01/2009

JE_PERIOD_ENDING_DATE is formatted as a short date, I am trying to get the running total of a salesperson for each year. Meaning that I want Jan+Feb then (Jan+Feb)+ Mar and so on throughout that year and then it needs to restart on the next year. I saw this code on another forum and applied...

Yea that is how the graph is arranged but what is an example of what the third field of data? Also, I made progress on the query. I got the running total to equal the sales number but it is not summing the data. If you could take a look to see what I am doing wrong I would be greatly...

Ok I have a form that has three comboboxes. They choose a year, a month and a saleperson. When the selections have been made it autopopulates a bunch of text boxes with certain data pertaining to that person. I need the chart to show the sales of that person for that year.

The reason that I am trying to use this is that I am trying to get the totals for the year so that I have the right data to put in a chart. The chart needs to be a line chart that is constantly increasing instead of showing the points as they increase and decrease. Sorry if that is confusing...

Thanks for the replies, pbaldy I changed the code to look like this: RunTot: Format(DSum("[TOTAL_SALES]","[TOTAL SALES]","EMPL_LAST_NAME='" & EMPL_LAST_NAME & "', "Format([JE_PERIOD_ENDING_DATE], 'yyyymm') = '" & Format([JE_PERIOD_ENDING_DATE],'yyyymm') & "' AND [JE_PERIOD_ENDING_DATE]-1 < #"...

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

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

Thanks that worked great!!