Search results for query: *

Hi, Date field called "Notifiedtime" gives date and time I wish to format this field to give me year and month only (200501 for january 2005) How can I format the field Any help would be very much appreciated Regards

Iam trying to add atrendline to project future maintenance cost. On one of the graphs the exponential trend field is not highlighted Is there any particular reason for it

Where can I get a list of codes such as TRUNC, DISTN to be used in MsQuery for both formatting and calculations

Could someone please explains how I could brouse the thread list and refresh my knowledge. At times experts advise others to look at a particular thread. How could I access that particular thread Regards Siva

Hi klmorgan Thanks for your help Gnanas

Hi,I get random colours whenever I generate graphs in Excel. Is there any way I can predetermine the colour of the graph. At times the colour is so bad for any printout Gnanas

Hi, I tried to use Insert>Name>Define to name a moving data range incoporating "OFFSET" function. I had no difficulties in creating the range name. However subsequently when I tried to edit the "refers" field in the range name I could not do it. The movement of arrow keys...

Hi PeterMoran, Your second formula worked very well Thank you very much Gnanas

I regularly import information from a maintenance database into Xcel for analysis. of teh database one column consists of date in dd/mm/yyyy hh:mm format. I then need to convert this column to yyyymm format. But I want this column to appear as text or number (e.g 200306). Even though cells...

I have a x-cel table like this work order mmyyyy expenditure 101 200201 150.00 102 200201 165.00 103 200202 185.00 for every mmyyyy we have many work orders with different expenditures. I need to find out the number of workorders in each...

Thanks Guys I have learned little more on functions Gnanas

Hi Fneily & Sfvb Thanks for your prompt reply It worked Gnanas

I have two X-cel tables, using Vlookup formula I try to extract information from first table into the second one for comparison and totalling up . In certain cells I get #N/A because values are not available which is perfectly correct. However I am unable to sum up the column becaues of #N/A...

You could easily use Pivot table to find the subtotals

Tks for all the advise. I have passed your information to our IT personnel for investigation and iron out the bug Gnanas

Hi RobCPA, No "Debug" button is available. After accepting the error message I can open the file and look at only the view list. I cannot bring up indiviual screens Gnanas

I received an access file via e-mail and when I tried to open The following error message came up "Object variable or with block variable not set" The same file was found to be functioning normally at the sender's computer. I then received a zipped copy and got the same error...

stevebausch nikita6003 cresby Thanks for your help. I hope I can build on your advise

I have started usuing VBA for excel applications. I am confused about some of the terminology used in VBA. Where can I find the full list of Codes used in VBA

I have been developing word 200 document detailing insructions for the preparation of monthly report by clerical staff. I need to embed toolbar Icons in that document. I have been getting a screen copy & paste then croping to get the required Icon which is very time consuming. Is there a easy...