Recent content by ThaoVy

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

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

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

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

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

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

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

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

Thanks so much! It works.

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

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

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

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.

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

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