Search results for query: *

I have two queries that have data that I need in one report. Query a1: Select fname, lname,state from contact where state = 'TN' Ouput data: fname lname state Kim Smith TN Jim Jones TN Sarah Lewis FL Joe Wills TN Query a2: Select fname, lname, state from...

I have created two queries in Microsoft sql server. I have two select statements that I have joined together and that works. The issue I have is I need the data in description to match shakeweight or armweight. If description = 'ARM SHANK' then shakeweight if description = 'ARM SHANK' then...

I have a query that I created in IBM DB2 database that display all report that are within the parameter 202010201 to 20210228 which is the Promise Date. I need to convert this code to Microsoft server. Here is the IBM DB2 code: (select a.* from ( select...

I have it working now, I add a Sub to Insert. Code: Private Sub InsertSql2(ByRef con As ADODB.Connection, ByVal strColumn As String, ByVal strRelease As String, ByVal rCell As DataGridViewCell) Dim strInsert, strWhere1, strWhere2 As String Dim...

I have corrected the code and created a insert Sub: Private Sub InsertDatabase() On Error GoTo errH Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset Dim strPath As String Dim intImportRow As Integer Dim objType As String Dim...

How do I add the insert Function to the update? I created a button and add this Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim strRelease As String Dim sqlStr, sqlStr1, sqlStr2, sqlStr3, sqlStr4, sqlStr5, sqlStr6, sqlStr7, sqlStr8, sqlStr9...

Here is the update queries I have: Private Sub UpdateSql(ByRef con As ADODB.Connection, ByVal strColumn As String, ByVal strRelease As String, ByVal rCell As DataGridViewCell) Dim strUpdate, strWhere1, strWhere2 As String Dim strNewSql As String...

I have created a program where the user enters a release number and retrieve the data to a DatagridView connecting to a IBM db2 database. The options the users currently have is: Clear, Retrieve, Validate, and Update. The issue I am having is if the record is not in the database it doesn't...

Thanks pmax9999 I have it working now. Here is what I did: if {@dateDiff} = 0 then "Week 0" else " Week "+ totext(Datepart("ww",{@Shipped_day})+ 1- Datepart("ww",({@Shipped_day} - Day({@Shipped_day})+1)),0,"") It display: week 1, week 2, week 3, week 4

The first week will be the first Monday of the month. For the First_Monday I only get one 'Y' and its for a shipped_day that is blank. (I put a 'N' where it If Not OnFirstRecord and {@Week_Number} <> Previous({@Week_Number}) and Day({@Shipped_day}) < 8 Then 'Y' else...

That worked for getting the week number of each row, but how do I get it to give me a week count for each row in the month? I need the first week of every month to be a color and so on. I'm not sure how this needs to be done but this is what I was thinking. I have a shipping date, if I could...

I have a Crystal Report and I need to have the backcolor changed for every week within the month. Week one Aqua Week two Orange etc. I have a formula field that have the date in mm/dd/yyyy format but I'm not sure how to find the week starting at Monday ending at Friday and putting a color to it.

Thanks again pmax9999 I got the sum for onTime and late. You are the BEST!!!!

Now I am trying to create two more formula fields: OnTime and Late using the data from the DateDiff formula. OnTime formula: if {@dateDiff} > 0 then Count ({@dateDiff}) I get 0.00 for this formula but should get 25 ( I am trying to get all numbers that are greater than 0) Late formula: if...

Thanks pmax9999, you helped me resolved the issue. I had a date of 99999999 in the SHIP_DT and needed to add it to the formula field If {Command.SHIP_DT} = 0 then date(0000,00,00) else [highlight #FCE94F]If {Command.SHIP_DT} = 99999999 then date(0000,00,00) else[/highlight] Date...

I have a report in Crystal report that has a promise date and a shipped day, both data types are number. The data is stored as yyyymmdd in the database (DB2) so I created two formula fields to change the date format to display mm/dd/yyyy. I have two parameter "StartDate and EndDate" and the type...