Selection criteria and Group by

[jeanluc.praz]

I have the following query:

http://www.corobori.com/sos/picSelect.jpg

This is counting projects and also approved projects and suming the
amounts.

This query is based upon a table, let's call it tblProjects, and my
users want to select from a dropdown list some criteria for instance
the project type.
How can I apply that criteria on the underlying table ?

Jean-Luc
http://www.corobori.com

 

[Tom Ellison]

Dear Jean-Luc:

I strongly recommend you post the SQL View text of your query here. It is
quite complete and most of us who answer questions can work from that. It
is also much easier to reply in kind, as text is native to both SQL and
newsgroups.

Tom Ellison