Search results for query: *

How do I add a group? How do I create a calculated control source? Sorry I am more used to DMBS such as Oracle and MYSQL, but the big boss asked for some updates on this so there is no argument Thanks

Here is the query: PARAMETERS date_start Text ( 255 ), date_end Text ( 255 ); SELECT DISTINCTROW Count(*) AS [SOE Count], SOE.SOE, Proposal_all.Subm_date, CDate([date_start]) AS start_date, CDate([date_end]) AS end_date FROM SOE INNER JOIN (Proposal_all INNER JOIN prop_soe ON...

Ok it works great thank you all for the help. Just one last thing, what if I want to the same search with different joined tables, how should I build the having? i.e. (wrng but to give you guys an idea) HAVING COUNT(DISTINCT ss.subsecto) = 2, COUNT(DISTINCT c.country) = 3 I tried it but to...

Thank,s guys so much It all works great now

OK thank you so much that is working great just what I needed just bear with me a little longer. The whole query is a little more complicated and more joins, that was the only one where I was having issues. Now i got the results I needed almost, using your query I get 14 results isung mine I...

I will try all that. Using 'or' works. The problem is use 'and' Several projects have both criteria and some more maybe, so i want ot know which projects have both criteria or 3 or 4, al query's are dynamically generated, so it is not complicated, the thing is to get to work first then program it

My table structure is: refsub (table name) PROJET SUBSECTO subsecto refsub (table name) SUBSECTO LONGNAME refchifrefsub (table name) projet descript refsub Subsecto is a fk to a table that contains a list of subsectors Projet is a FK that links the subsector to the project subsecto...

I jst installed MS CRM 3.0 and when I installed the email touter for exchange and configured an account to it, all emails in the inbox from that accoutn disapeared and new emails also disapeared when send/receive was pressed. I have removed the froward policy from the email router so new emails...

Thank you very much, but I have one more question, how do I doi what you told to do? Sorry to bother you Thanks

We had major hardware failure a few weeks ago, and after changing MB and Proc and repairing windows everythign workd ok as before. Then when trying to instal SP1 y have an erro that I hace to be A member os admin, schema and domain groups, While Using the Administrator account, which it usually...