Search results for query: *

That was easy Thanks!

How do you create a drop down box in a cell with the only choice of Yes or No?

I did read the help and found it a bit confusing. So if my results for the 19 months is -26.0%. That means what?

Thanks for the info. The formula works, can you explain what this formula is doing? Why doesn't a positive # work for the guess and why doesn't the value change when I use guess of "-.5" or "-.9"?

I am using the IRR function and I am getting #DIV/0! returned. When I check my data there is no zero value. Here is my formula. Can you tell me why I am getting #DIV/0! =IRR(B6:T6)*12 Here are my values: ($24,000.00) ($128,448.45) ($30,000.00) ($100,000.00) ($27,000.00) ($50,000.00)...

Dale, That sounds great. I will go through the data tomorrow and will send you a sample worksheet. The feature which sends the graphs to powerpoint sounds great as well. I will communicate with you soon Regards, Michael

What I would like to do is click a button that runs code, which creates bar graphs of my data. Mytable columns: Description, Part ID, Fab, system division, total/partId for each part Id I have different fabs, systems and total/partId. Iknow what I want to do however I don't have much...

I forgot to mention that the excel data is comming from Access. My alternative would be to create the charts in access, and export them to excel. I never used chart in Access. Can anyone help with this alternative. Please refer to my initial question. Thank you.

I'm only a little bit familiar with vbscript, but is there a way to create a macro to graph my data. My table columns are (name, part,fab,totals,division and totals/part.) I would like to create a different graph for every part. The x axis would be fab and the y axis would be totals. I am...

Worked well! How do I add in the leading and trailing 0 before and after the decimal place.

Sorry for the confusion! Sample data: 0 00 000000 000000-000-00 000-000-00-000 Each month I receive new data and I won't know in advance how many part id will have data like the above, and what combination of zeros and or dashes they will have. Any Part id that contains zeros with or without...

SELECT system, total, system/total AS [sys/total] FROM table; Iwould like to return only one decimal place instead of many for [sys/total]. How can I format to one decimal place?

Bob, I'm not sure what you are doing on the WHERE clause. It looks to me that the only value that won't be selected is the one you listed, or are you saying to make a WHERE clause like this WHERE [part id] <> '0' AND <>'00' AND <> '000', etc.?

Select CLng([Part ID]) From table WHERE [Part ID] >0 I get an error in the expression. Problem out of the over 20000 rows some of the part ids have letters. Would this blow up the Clng function?

I have a select statement that includes [part id] The excel table that I am linking to has &quot;dirty data&quot;. Some [Part Id] have been assigned 0,00,000,0000,etc. [Part Id]is text not a number. I am performing a COUNT function on [Part ID] and it counts the [Part Id} with the...

As it turns out I did not realize that I had a table named the same as the query. This table had some of the same info, making it confusing. I did not need the table and deleted it and my export runs fine. Thanks

I am running Access 2000. I have created a link to an external excel file and I am running a number of queries on this link. I am trying to export the results of one of those queries back to the same excel file. I created a macro to do this in the macro in the macro window. I am exporting...

Got it, Its easy once you know the way Thank you

In design view I clicked on the button and in properties window clicked EVENT and ON CLICK. However, I did not see the click procedure in my module? MW

Sorry, I am using Access. I have written vba code in Access. I would like to know how I can run this code from a form in this database. I created a form, and put a button on it. I am trying to figure out how to run the vba code when I click that button. When I created the button I had a...