Search results

How can i calculate median using access query. Is there something as simple as aggregate functions like SUM, AVG etc for calculating Median? Please help. Thanks

got it working got it working using SELECT TOP 2 [Date], CloseDiluted FROM tblSecurityDay WHERE SecurityID = 1074 ORDER BY [Date] DESC

My data looks something like this SecurityID Date CloseDiluted 1074 02/02/2005 0.09 1074 11/10/2004 0.1 1074 09/07/2003 0.1 1074 28/06/2002 0.13 1074 06/08/2001 0.2146524 I want my result set to show records for most recent date and date prior to it? Eg. SecurityID Date CloseDiluted 1074...

Thanks a lot for helping out.

Thanks Jon K. Out of curiosity, is there anyway of achieving similar result with one query rather than using two queries.

My data look something like this CompanyKey Date Status Price Price_Dil 1 01/12/1997 H 1.40 1.38 1 26/08/1998 N 0.81 0.80 1 12/02/2004 H 1.54 1.54 1 11/08/2004 N 1.41 1.41 4 17/03/2000 H 1.30 6.50 4 21/09/2000 N 0.52 2.60 5 01/12/1997 U 1.13 1.11 5 02/03/2004 U 1.78 1.78 9 01/12/1997 U 9.85...

I tried this query and didn't get any result. What cud be wrong??? I do have data b/w those two dates in my table. SELECT DPS FROM tblDividend WHERE CompanyKey =1582 AND Period BETWEEN #1/09/2004# AND #1/12/2004#; Following is the data in tblDividend CompanyKey DividendType...

someone suggested this SELECT tblDividend.CompanyKey, Sum(tblDividend.DPS) AS SumOfDPS, Max(tblDividend.PeriodEndDate) AS MaxOfPeriodEndDate, Max(tblDividend.ExDividendDate) AS MaxOfExDivDate FROM tblDividend WHERE CompanyKey =1582 GROUP BY tblDividend.CompanyKey, Year([PeriodEndDate])...

My data looks like this in table tblDividend CompanyKey DividendType PeriodEndDate DPS ExDivDate 1582 Q2 30/12/2001 0.03 25/01/2002 1582 Q4 30/06/2002 0.03 23/07/2002 1582 Q3 30/06/2002 0.03 22/04/2002 1582 Q2 30/12/2002 0.03 22/01/2003 1582 Q1 30/12/2002 0.03 23/10/2002 1582 Q4 30/06/2003...

thanks Bingo, worked like a treat

how can i calculate number of days in current month using access query

I have following query written in my Access DB. SELECT PriceVale FROM tblTrans WHERE ItemID = 1001 My problem is I want this query to return 0 if record is not found in the table. Apparently it returns empty field. I tried using Nz functions as follows, but still it doesn't return 0 SELECT...