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

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

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

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

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