QUERRY: WHAT'S THE PROBLEM???

[FlavioT]

Hi!! I'm getting crazy here... I'm trying to put a limit to the values... This first SQL works great... But when I try to link the HAVING condition to a Form it show all the records!! WHY?

What is [Formulários] is my Portuguese Access for Forms.
And YES... this object exists!

Does anyone have a clue??????
SQL1: Works great!
SELECT DISTINCTROW CPF.Nome, CPF.CPF, Sum([valor])-Sum([valor pago]) AS Dev, Count(CPF.CPF) AS ContarDeCPF
FROM CPF INNER JOIN Cheques ON CPF.CPF = Cheques.CPF
GROUP BY CPF.Nome, CPF.CPF
HAVING (((Sum([valor])-Sum([valor pago]))>2000))
ORDER BY Sum([valor])-Sum([valor pago]) DESC;

SQL2: Doesn't work!
SELECT DISTINCTROW CPF.Nome, CPF.CPF, Sum([valor])-Sum([valor pago]) AS Dev, Count(CPF.CPF) AS ContarDeCPF
FROM CPF INNER JOIN Cheques ON CPF.CPF = Cheques.CPF
GROUP BY CPF.Nome, CPF.CPF
HAVING (((Sum([valor])-Sum([valor pago]))>[Formulários]![Formulário1]![Texto0]))
ORDER BY Sum([valor])-Sum([valor pago]) DESC;

 

[jmersing]

"Having" can sometime give erratic results. I find it best to use "where" as opposed to having. On your join you may wnat to force all of the records from on table and show only the matching records in the other table. Do that by including bith queries in a new query link them by dragging your join field and then right click the join line and select a join that will force the records from one table. Try it a few different ways, it might work for you.