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!

  • Congratulations strongm 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. ms901Boss

    Join two select statements and collecting data from both

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

    Joining two select statement into one

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

    Converting DB2 query to Microsoft Database

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

    Trying to update and insert using the same button in vb.net

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

    Trying to update and insert using the same button in vb.net

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

    Trying to update and insert using the same button in vb.net

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

    Trying to update and insert using the same button in vb.net

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

    Trying to update and insert using the same button in vb.net

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

    Crystal Report Backcolor Change by week

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

    Crystal Report Backcolor Change by week

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

    Crystal Report Backcolor Change by week

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

    Crystal Report Backcolor Change by week

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

    Crystal Report with DateDiff

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

    Crystal Report with DateDiff

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

    Crystal Report with DateDiff

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

    Crystal Report with DateDiff

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

Part and Inventory Search

Back
Top