Search results for query: *

I am using Excel 2007. I use MSQuery to connect using ODBC to an Oracle server and get data into table. I am trying to use subtotals, but it seems not working with data from table!! Can anyone support how to overcome this issue or use a VB macro to dynamicly calculates subtotals as table is...

Is there any possibilities to share a workbook that contains sheets with data retrieved and updated from external ODBS sources? Is there any workaround, special add-ins, 3rd-party tools or other Microsoft solutions?

My vista gave me the option either to update online or through the admin controlled update. Both are working, but the default is that of the domain. Can I change the default?

I have tried the above solutions and it seems that the WiFi driver of the Dell on the Vista SP1 is not functioning well. The Bluetooth icon disappears after a while as if the bluetooth is no more present, while the lamp is on!!! Any suggestions?

Yes, this is the company policy since they do not need any updates that may turn their clients unstable and overload them with user supports. For me, I do not need their support, but only need to access inbox and use proxy and other services while am in the company. I do not need to be...

I had VISTA 32 on my DELL latitude D520 and recently installed Vista SP1 and Nokia PC Suite 6.86.9.3. Suddenly, my bluetooth connection with my Nokia mobile N70 is no more working. I think this is mainly due to the VISTA and not due to the PC Suite. This is because the Bluetooth icon start in...

I have recently joined my company domain. The domain administrator has set the group policy to make windows update managed by system administrator by default. How to make the default windows update being through online update rather than the domain update?

I need to use my Outlook 2007 to send/receive emails using the http connectivity with Exchange 2007. This is done inside my company, and am able to use Iexplorer to login to my inbox from outside the company. Now, I need to do this using my Outlook 2007. My company admin does not provide my any...

Many thanks. The results are exactly match my needs.

Many thanks for your support.

I understand the code and testing the results. Still waiting for the server to finish.

My oracle database server is version 8. This is part of the Oracle ERP old version 11.0. I need this SQL to provide a table that I will use it to in determining effective forecast date range. Actually, there is an additional column not shown representing the relevant quantity. The date format...

I have a table with the following data: Code Effective_date A 1/1/2008 A 1/2/2008 A 15/5/2008 B 1/1/2008 B 15/2/2008 C 1/2/2008 C 1/4/2008 I need to get the following output: Code Effective_1 Effective_2 A 1/1/2008 31/1/2008 A...

I am using VISTA business SP1 on Dell Latitude D520. I just joined a new Domain in my company network. After this recent join, I am not able to find my boot system drive C in explorer or my computer. However, when I write C:\ and press enter, It displays. Has anyone any idea how to be able to...

Many thanks for your support. Your solution worked fine for me. I got another solution, but seems to be more complicated than your simple one: {=SUM(MMULT(DataArea*--(Code=A10);--(TRANSPOSE(DateRange)<TODAY())))} This is based on Matrix multiplication. What do you think, which one will be...

Actually row 1 contains real dates that represent the first date of each month.

I forgot to say that the sumifs function i used is not working and gives value#. I need assistance for other solutions any expert of you has used.

I have a sheet with the following data: A B C D E F G H M 1 Code Jan Feb Mar Apr May Jun Jul ------- Dec 2 A 10 11 1 5 9 3 10 8 3 B 4 2 33 9 1 0 12 4 4 C 5 D...

Thank you SkipVought. Your solution is straight forward to my need. Although it looks simple, but I am messed with data analysis and was blocked and unable to think for the solution you provided. The reason for what I need is to monitor the sales patterns of products through LINEST(). Column A...

What will be the formula to be used in Column C to provide the output indicated? Please note that the content of Column A and B in the example are actually names with no explicit relation based on the description. Say Codes for example. I am saying this in order not to consider Column B...