Search results for query: *

You're a genius! Thank you

Hi John, I don't get an error message- but it just doesn't change. I click run and then it freezes- the little blue squares down the bottom left hand side of the screen that form when you run a query don't appear. Yes MyDate and Datestring are both Date/Time formats. In this sample one of...

Me again... Could you offer any advice as to why it doesn't work. I press run but it doesn't run. My SQL is SELECT EarningsDates.*, MktCapValues.MyDate, MktCapValues.Field6 FROM EarningsDates INNER JOIN MktCapValues ON EarningsDates.Ticker = MktCapValues.Field2 WHERE (((...

Hi John, Sorry about this. The query runs now- however, I'm getting every value for each stock. So if I want only the market cap for company A at 29/06/2002 I will get every market cap for company A in the market cap table. Can you help? My sql is SELECT DISTINCT EarningsDates.*...

Hi JonFer, I'm having some difficulty. My tables are called EarningsDates MktCapValues I have written (SELECT Max(MktCapValues.Field2) AS Expr1 FROM MEarningsDates, MktCapValues WHERE (((MktCapValues.Field2)=(EarningsDates.Ticker)) AND ((MktCapValues.MyDate)<=(EarningsDates.Datestring)))); I...

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.

I don't think I'm explaining myself properly. Table A= Earnings Announcements Company Name Dates EarningsValue A 31/03/1993 1.04 B 01/04/1993 1.04 (Annual data- A company releases earnings annually) Table B= Returns Company Name Dates...

I don't think that will work. I need to make sure that the date I get corresponds to the same company. I also want the data for all the 54 days. Doesn't this mean that I need to specify the company?

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...

Your wonderful! Thank you

Hi Ken, Thank you for the assistance. However, having a little difficulty. When I use this query it says I am about to update 0 records. Am i doing something wrong? Thanks again

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

No it has many dates. Basically, it is monthly data beginning in 1994 and ending in 2003. For eg 199401 199402 199402 199403 etc

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.