Search results for query: *

I am trying to group data by column labelled 'project'. But, it is grouped as one step only. I sorted out the data and carried every step in Excel help page. Still does not work. Thanks in advance project product aa 23 aa 25 aa 56 bb 48 bb 56 cc 56 Guru

In Visio, click on File > New > Browse Sample Drawings. This has some good samples to start with. Microsoft Visio site has some help. Good luck. Guru

I once inserted an organisation chart in a visio file and deleted it later. But everytime I open the drawing Organisation chart toolbar and menu appear. When I close the drawing, it pops up an error message with report to Microsoft dialogue. How do I disable or eliminate this Organisation...

There are heaps of postings explaining how to make dynamic range as Pivot table source. I discovered that Excel has this built in. In Excel, Insert>Name>Dynamic Range Name... does this. Good Day. [hairpull3] Guru

I fiddled around and discovered something. The error was due to blank lines. This criteria is not mentioned in any help file. Guru

I am trying to group dates to months in Pivot table. It worked once. But, subsequently I keep getting error message 'Cannot group that selection'. I read other related postings in this site and did exactly as given. But, still does not work. Please help. Regards [elephant2] Guru

I have Hlink to a Powepoint document. When I click the link, powerpoint document is opened in internet explorer. How do we make that document to open in powerpoint itself? Or for that matter, how do we make a document open in its own application? Thanks Guru

1. In query, right click ina any field row and select Total. Select Category and No in the rows. Select 'Group By' in Category and No Columns. It should display grouped on these two columns. It is not a good idea to mix number and text as you may face problems while sorting but, if you do not...

Please find below the SQL statement. Thanks for your interest and help. SELECT tblTravelCheque.TravelID, tblTravelCheque.TCCurrency, Sum(tblTravelCheque.TCAmount) AS SumOfTCAmount, tblTravelCheque.ConvCurrency, Sum(tblTravelCheque.ConvAmount) AS SumOfConvAmount...

tbl_TC contains the following fields TC_Id TC_Currency TC_Amount Conv_Currency Conv_Amount tbl_TCAdvance contains the following fields TC_ID Adv_Currency Adv_Amount I build a query taking all fields from tbl_TC with a join on TC_ID from tbl_TC and TC_ID from tbl_TCAdvance, and...

In a query, I use a field from another table as criteria. If I use the table column address, it works fie. But, when I prefix it with 'NOT' or 'NOT LIKE', it does not filter the records. The query displays all records. Is NOT or NOT LIKE the correct syntax? Thanks [shadessad] Guru

Thanks Dale. I've e-mailed the file. The sample does not work if the variable is in date format. It works fine for text or integer. Thanks again [2thumbsup] Guru

Thanks. I do use range. The range I use has 5 columns. Each column is made up of merged cells. When I refer to cell to look up, I did give the actual column count. eg. 31 instead of 5. Then I unmerged the cells and tried. But, I still get this message Thanks Guru

I am trying to use VLookup function in Excel VBA. Eventhough I use the syntax application.WorksheetFunction.VBA(______) it throws up an alarm Unable to get the VLookup property of the WorksheetFunction Class. I was successful in using the same syntax for Max function. Is it the limitation with...

I have a subform with controls ExpAmount,Avg_ConvRate, ExpAusDoll, etc. Forex value is acquired from another crosstab query. ExpAusDoll is product of ExpAmount and Avg_ConvRate. The variables are declared in module level When the following sub-procedure are run in successsion, it puts...

did you mark the workbook as 'shared workbook'? Go to Tools, Share workbook,..... and chage it. Good luck [2thumbsup]

I am running Office97 in Windows 2000. When I try to use right, left or mid functions in VBA, i get error messages - 'Object or Library not found'. I tried the same thing on another machine with same configuration and it works fine. Please help, thanks.