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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ThaoVy

  1. ThaoVy

    query with Union ALL

    Hi, Hope this one would clarify a little bit. Below is my codes for Microsoft Visual Basic: Dim SQLquery as String SQLquery = "SELECT DISTINCT tblProjects.ProjectNum, " SQLquery = SQLquery & "tblProjects.EngReceivedDate as RecvdDate], " SQLquery = SQLquery &...
  2. ThaoVy

    query with Union ALL

    I am so sorry for the confusions. Hope the below would help. Also, I am so sorry for the long queries. Private Sub Find_Click() On Error GoTo Find_Click_Error '_____________________ '| | '| Find Activity | '|___________________| Dim MyDb As Database, MySet As...
  3. ThaoVy

    query with Union ALL

    In my form under search by employee last name button,I have something like this for a Event Procedure: Private Sub B2_Click() On Error GoTo B2_Click_Error Me![FLastName] = "" it would display data based where tblProjects.AssignedToID = tblEmployees.EmployeeID ........... I would need it also...
  4. ThaoVy

    query with Union ALL

    Hi, I have it as it is a string. Dim MyDb As Database, MySet As Recordset, SQLquery As String. Is it what you need? Thanks
  5. ThaoVy

    query with Union ALL

    Hello, I just want to see if anyone would be able to help me to incorporate UNION ALL to the above SQLquery ? Below is my current SQLqauery and it works just fine. SQLquery = SQLquery & "tblEmployees.LastName " SQLquery = SQLquery & "FROM (((((tblProjects INNER JOIN tblAccounts ON...
  6. ThaoVy

    query with Union ALL

    it is a string. Dim MyDb As Database, MySet As Recordset, SQLquery As String
  7. ThaoVy

    query with Union ALL

    Hi, This is what I currently have for this form and it works just fine: SQLquery = SQLquery & "tblEmployees.LastName " SQLquery = SQLquery & "FROM (((((tblProjects INNER JOIN tblAccounts ON tblProjects.CustomerID = tblAccounts.CustomerID) left JOIN tblProjectBusinessTypes on...
  8. ThaoVy

    query with Union ALL

    Hi, When I do a search, I would like my form to show all the projects that a person is assigned to + Projects that he/she Performed By. Below is what I have; however, it does not give me any record. SQLquery = SQLquery & "tblEmployees.LastName " SQLquery = SQLquery & " ((FROM (tblProjects...
  9. ThaoVy

    Records display multiple times

    Thanks so much! It works.
  10. ThaoVy

    Records display multiple times

    Hello, If I do a maximum training date, it would show only max date. I actually want to show both dates: one for Demo Competed and the other is training date. Right now, it would give me 2 records. I need it to show as one record with dates for Demos and Training: CustName Proj#...
  11. ThaoVy

    Records display multiple times

    If I do antoher groupong on business type formula, I will then have 2 records for the same Project if it has 2 business type: CustName           Proj#      RecDate         Demo Completed    Training Date Thomson West    9447SC    03/02/2007         03/11/2007 Thomson...
  12. ThaoVy

    Records display multiple times

    Hello, I have a tblProjects where each Project# is entered once. I also have a tblProjectBusinessTypes where Project# is entered multiple times with different BusinessType i.e. Consulting, Product Demos, or Training and etc. I am using CR 10 and on the report, under the detail section, it...
  13. ThaoVy

    Problem with grouping not sum up correctly

    Hi, Normally, it takes only a minute to run the report. After I insert a Command, it's been an hr and 45 minutes. however, the report only reads at 28%. any suggessions. Thanks so much.
  14. ThaoVy

    Problem with grouping not sum up correctly

    I tried to insert a summaries earlier. However, when I clicked Insert Summary, under "Choose the field to summarize", the formula_{@LastUpdate (%)} is not there. Neither DaysLastUpdate or LastUpdate. Thanks
  15. ThaoVy

    Problem with grouping not sum up correctly

    Hello, I am using CR V 10. Below is my formulas: LastUpdate: Maximum ({tblStatus.EnteredDate},{tblStatus.ProjectNum}) DaysLastUpdate: DateDiff ("D",{@LastUpdate} , CurrentDate)- (DateDiff ("WW",{@LastUpdate} , CurrentDate)*2 ) LastUpdate (%): If {@DaysLastUpdate} <= 3 Then "100%" Else...
See more

Part and Inventory Search

Back
Top