Search results

  1. skipit

    Change Network user name to Noted DB name (Len, Trim and such)

    Morning all, I am having some trouble grasping the idea behind Len, Trim and such (I think this is what I need to use). What I need to do is change the network login name into the db name for a Lotus Notes db. Here is the format of each: Network Login (I pull this into my DB and save as a...
  2. skipit

    Concatenate and Null values

    Morning all, Thanks to help from this forum I have the following SQL for one of my queries: SELECT [qryMain2-17].JCI_PN, [qryMain2-17].JeffCityPN, [qryMain2-17].ProgramID, [JCI_PN] & " " & "" & " " & [JeffCityPN] & " " & "" & " " & [Desc1] AS PartNum, "Center ILD:" & " " &...
  3. skipit

    Take data from columns and put in rows

    Hello all, I have a table that is imported from some test software we use. We do a test of three parts with a reading for each part which would make a Series of three. See below.. PartNum Reading SeriesNumber SubSeriesNum RecordDate G1234 150.5 2212 1...
Back
Top Bottom