Search results for query: *

When I highlight my data and start the chart wizard to make a scatter plot, excel never properly (or logically) assigns the cell references in the series tab (step 2). Instead I have to manually enter the cell ref for each entry for the x and y axis. Is there a different way to do this...I have...

I have created a scatter plot w/lots of pts and instead of having different shapes for each entry I want them all to be a black circle. Is there an easy way to format all the points at once?

Thanks everyone! I used Richard's method w/the absolute references and it worked.

How can I do a cumulative addition in excel? ie: the first entry would be 3.2 , the second one would be 3.2 + 3.9, the third one would be 3.2 +3.9+ 4.4...etc. There is no sequence to the numbers, it is just a cumulative sum of the previous column. Any easy way to do this without having to do...

Thanks...that worked. I didn't realized I had to join them In the design query.

I've already created the combo box, and its value changes based on the value of another combo box, which took me a long time to complete, so now I can't go back and change it. I was just wondering if theres a simple way to do it at this juncture.

How should I join the tables to avoid this problem?

When running the procedure this is the line that is giving me a problem: If Me.Combo35 = rs("LocationAddress") Then What should be going into these fields?

The code isn't exactly working...it keeps returning 0 values for every field instead of looking up the actual record.

Rolliee, I tried your idea and it worked out! I added to the click event and it worked... Thanks!

I would like my 'Initiative' combo box (cboInit)to look up the appropriate record once an initiative is chosen. How do I go about doing that?

The Me![cboInit].Requery procedure isn't solving the problem. I still have to close out of the form and open it again before the update happens.

Rollie, I don't really understand what you're saying...exactly what should I do to reset the record source of the control? Thanks

Bob, I tried adding that procedure and its still not working.

Should the ID be the same on each table? Basically, I'm just trying to relate the initiative in the projected table to the exact same initiative in the actual table. So I assigned autonumber, hoping that initiative 1 would relate to initiative 1, 2 to 2, etc. I could very well assign some sort...

will there be too much redundancy...should I divide the 2 large tables into smaller ones?

I've been able to get a selection from the 'Division' combo box (cboDiv) to change the options available in the subsequent 'Initiative' combo box (cboInit). The problem is that the initiative box doesn't keep updating everytime I choose a different division...it only changes once I close out of...

Is this a good table design or am I setting myself up for disaster in the future? I have set up two access tables: Projected and Actual. Each table has exactly the same fields, except one is projected and the other is actual (example: Revenue/Actual Revenue; Cost/Actual Cost). There are also...

I created a query based on 2 tables: Projected and Actual. Both tables are exactly the same, having all the same fields, except one is for projected values and the other is for actual values. The query is set to calculate the difference between actual and projected for all the fields (ie...