Dates in 2008 don't work

[aceavl via AccessMonster.com]

hi, i have a query that works fine untill 01/01/2008 how can i fix this???

SELECT tblCo.CoNombre, tblEmp.EmpNombre, tblEmp.EmpFechaVenta, tblEmp.
EmpMonto, tblEmp.EmpCan, Sum(tblPay.PayMonto) AS EmpPay
FROM (tblCo INNER JOIN tblEmp ON tblCo.CoIDPK = tblEmp.CoIDFK) INNER JOIN
tblPay ON tblEmp.EmpIDPK = tblPay.EmpIDFK
GROUP BY tblCo.CoNombre, tblEmp.EmpNombre, tblEmp.EmpFechaVenta, tblEmp.
EmpMonto, tblEmp.EmpCan
HAVING (((tblEmp.EmpFechaVenta)>=[Forms]![Ventas]![Com_From] And (tblEmp.
EmpFechaVenta)<=[Forms]![Ventas]![Com_To]) AND ((tblEmp.EmpCan)=0));

Help please!
thanxs

 

[aceavl via AccessMonster.com]

ok, i found what was wrong.

the table PAY had no records to show so it canceled everything!
sorry for wasting everybodys time! lol

thanx

 

[John W. Vinson]

hi, i have a query that works fine untill 01/01/2008 how can i fix this???

SELECT tblCo.CoNombre, tblEmp.EmpNombre, tblEmp.EmpFechaVenta, tblEmp.
EmpMonto, tblEmp.EmpCan, Sum(tblPay.PayMonto) AS EmpPay
FROM (tblCo INNER JOIN tblEmp ON tblCo.CoIDPK = tblEmp.CoIDFK) INNER JOIN
tblPay ON tblEmp.EmpIDPK = tblPay.EmpIDFK
GROUP BY tblCo.CoNombre, tblEmp.EmpNombre, tblEmp.EmpFechaVenta, tblEmp.
EmpMonto, tblEmp.EmpCan
HAVING (((tblEmp.EmpFechaVenta)>=[Forms]![Ventas]![Com_From] And (tblEmp.
EmpFechaVenta)<=[Forms]![Ventas]![Com_To]) AND ((tblEmp.EmpCan)=0));

Help please!
thanxs

What "doesn't work"? Error message, wrong data, no data? What are the values
in EmpFechaVenta that you expect to see and don't, or that you see which you
don't want? What values are being entered into [Com_From] and [Com_To]?

More information please!

John W. Vinson [MVP]