Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. claufranck

    Help with ms access 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
  2. claufranck

    Help with ms access query

    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...
  3. claufranck

    Complicated single table query

    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...
  4. claufranck

    Complicated single table query

    Thank,s guys so much It all works great now
  5. claufranck

    Complicated single table query

    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...
  6. claufranck

    Complicated single table query

    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
  7. claufranck

    Complicated single table query

    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...
  8. claufranck

    Microsft CRM server problem

    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...
  9. claufranck

    Huge problem Admin Account

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

    Huge problem Admin Account

    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...

Part and Inventory Search

Back
Top