Radshaykho
asked on
MS ACcess 2007 Count query
Hi,
I trying to get the count of all records that are less or equal to 12/31/2010.
I am getting 0 results where I should have over 2500 count. But, when I change to > it will return all records count.
Your advice will be appreciated!
Thanks,
Rad
I trying to get the count of all records that are less or equal to 12/31/2010.
I am getting 0 results where I should have over 2500 count. But, when I change to > it will return all records count.
Your advice will be appreciated!
Thanks,
Rad
SELECT Count("Starting_Date") AS 2010_Count
FROM My_Table
where "Starting_Date" = #12/31/2010#
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
where [Starting_Date] <= #12/31/2010#
OM Gang