Dates in 2008 don't work

  • Thread starter Thread starter aceavl via AccessMonster.com
  • Start date Start date
A

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
 
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
 
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
Click to expand...

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]
 
Back
Top