Search:

Joe,

Thanks. I'll give it a try.

Julie

Hello,

I am trying to help my father in law install a new all in one Lexmark printer. When I am installing the software, the computer is telling me that it is missing the following file: ...

Thank you! Thank you!! Thank you!!! to everyone who has been helping.

By changing the properties, it works. I have imported new data with varying lengths about 6 times and so far no #REF!.

Thank you for your response.

It will work with column A - because there are no calculations. However, I can not copy it over into column B because it has calculations.

Thanks.

Attached is a copy of the workbook. The first sheet called "Data" is where the data is imported. To import, I go to Data/Get External Data/New Database Query...then I find my Access Database and...

Thanks for your reply. I am doing exactly that - edit/clear contents. It does not work.

Hello,

I have multiple sheets in one workbook. The first sheet imports the data from Access.

The second sheet does calculations based upon the data from the first sheet.

We are using...

Hans,

Thank you very much. The importing to Excel is working like a charm. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

I may not be using the correct terms to explain. I'll try again. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

I would like to have multiple sheets within the same...

Hello,

Is it possible to export to a specific worksheet in Excel. Every time I export, I create a new Excel file. I would like to have a workbook that includes calculations on one sheet and the...

Hans,

Thank you so much!!

I will also check into SPSS, SAS and SPlus and see if it will fit our needs.

Skew indicates the level of symmetry or lack there of.

OK. Thank you for your response...

I am asking nicely. Can someone write a user-defined function in VBA for SKEW?

Thanks.

I could use some help with calculating a skew. I looked in help and it has the following:

SKEW(number1,number2...)
Number 1, Number 2,...are 1 to 30 numbers or references that contain number for...

Thank you Hans and Mark for your input. This helps a lot.

Hello,

I am trying to calculate the correlation coefficient in a report. I looked in help which told me to use correl(array1,array2). So I tried the following: =Correl([netreturn],[netreturn1])...

Thank you - it works like a charm.

Hello,

I have a form which lists the net returns for 4 mutual funds at one time. The data is put into a temporary table from 4 update queries and then is used for the purpose of this form.

The...

They are in continuous view.

Mark,

This sounds very easy, but I am unsure what steps to take to do this. When I make command buttons, I use the wizard. Do I run a macro to requery? If so, when I have the action that says...

Yes.

Rupert,

In the critieria of the underlying query, it asks for a fund id. The user then types it in and the query runs.

Thanks.

Hello,

I have a user who would like to review the net returns of 4 mutual funds at one time. The user types in the individual fund id to run the queries. So far, I have a main form and 4...

Thanks Francois for all of your help. I need to study this query so that I understand it and can apply this method in future queries.

Thanks again!!

I have tried attaching the test database which is 10 mb and then I zipped it and it won't attach. I keep getting a message from the lounge to try again later.