Search results for query: *

Hi, I need some help. I have two tables- Table 1 has earnings dates Table 2 has Daily market cap. I want the market cap of a firm on each earnings date( i am aware this can be done by simply matching the companies and dates of the two tables). My problem is not all my earnings dates are in the...

Hi, Can anyone help? I have a table which has Company Value A 1 A 2 A 3 B 1 B 4 I want to calculate the standard deviations for each firm. How do I create a query that states for each company calcuate the SD if all the values then for the next company...

Hi, I need to disable windows shutdown process. How can this be down without changing the registry? Thanks.

Hi, I am trying to extract some data from a table. Table A has Company Name dates EPS value (approx 3400). This is annual data Table B has Company Names dates Daily return This is daily data (approx 70000 records) I need to match up the company names and dates in A and B. This is...

Hi I'm trying to change a number format to a data/time format. But it doesn't work- my entries are deleted. Currently my numbers look like 19900231 etc so they look like dates Can anybody suggest anything? Thank you

Can anybody be of assistance? I have a column of entries of the format DDU.ASX ANC.ASX YGT.ASX I want to remove the .ASX so my column entries read DDU ANC YGT Can this be done in ACCESS? I know I can use the left function in excel Thank you

Hi...Help please. Say I have a matrix that has dates as coloumns and company names as rows ie 1994 1995 1996 A 1 5 3 B 1 3 7 I want to change the layout so i only have three columns A 1994 1 A 1995 5 A 1996 3 B 1994 1 etc Can anyone suggest anything? Thanks and...

Can somebody please help? I have a matrix in excel and it has a total asset figure for each company one month in each year. I want to carry over this figure into the remaining months until a new figure is released. For example- The rows in my spreadheet represent companies The columns in my...

Can somebody please help? I have a matrix in excel and it has a total asset figure for each company one month in each year. I want to carry over this figure into the remaining months until a new figure is released. For example- The rows in my spreadheet represent companies The columns in my...

Hi, Can somebody please help? I have a date of the form YYYYMMDD and a FY end date of YYYYMM. Is there any way of cutting the period date to be of the form YYYYMM so I can match it with the FY end date? Thanks and much appreciated.

Hi, I have two tables. End of year results Interim results Date Result Date Result I've made a union between the two tables, but I want to say that when the dates are equal (but the value of the 'results' won't be)- choose the value of the "End of year results...