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 Mike Lewis 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. corbinap

    Create a form for responses and send

    Hi all.. I need help understanding best way to create an outlook form with questions where the receiver will input answer and send back
  2. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Thanks for the quick reply - I am just now getting a chance to work on. yes getting rain also.
  3. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Here you go - thanks in advance. curious what doing wrong. https://files.engineering.com/getfile.aspx?folder=c28b7586-75f2-41ae-97b1-d6ed1c872b2f&file=example_8.xlsx
  4. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Hi Skip, the version of Excel I am using has Unique function but the formula returns 0 (zero). I have tried what you used for the ID and Title and I tried a range E2:E20. Nothing works. I also get an error that says using "=" or "-" is for formula.... so close - I have the table formulas...
  5. corbinap

    Find verbiage and transpose values between each row with the verbiage

    Thank you - I did not know how well I explained but yes normalizing makes sense but never had to do in Excel - worked with Access alot in past. I will let you know - again thank you
  6. corbinap

    Find verbiage and transpose values between each row with the verbiage

    I am needing to get values between rows with same verbiage in title. Really need help as will have a lot of records to go through. Provided file. IT might help to move the Verbiage to another column ID Title the Values under Title Status Thanks in advance Sub Transpose_my_cells()...
  7. corbinap

    Do loop to find text and add verbiage if found in another column

    Thank you but I need an array and have reposted also as need more help. Thx
  8. corbinap

    Do loop to find text and add verbiage if found in another column

    Do loop to find text in row and add verbiage in column based on value. Hi and thanks in advance. I am looking for a way if a word is found in a row then a value under the row will be moved to a column example and see attached. If "Stock" is found in column B row and column C shows "Good" then...
  9. corbinap

    Conversion error for date

    Thanks for all of the suggestions.
  10. corbinap

    Conversion error for date

    I am getting an error: Conversion failed when converting the nvarchar value '10/2007' to data type int. using: a.[calyearmonth] = b.[calyearmonth] - 1 calyearmonth is a nvarchar and I need to get previous month in table b. Do I need to covert calyearmonth somehow?
  11. corbinap

    Month to 2 digits

    thanks...
  12. corbinap

    Month to 2 digits

    But, I also need to add the 4 digits year in the front: yyyymm Declare @LastMonth varchar(2) SET @LastMonth = right('00' + convert(varchar(2), Datepart(mm,getdate())-1), 2); select @LastMonth
  13. corbinap

    Comparing two columns in different tables

    I have seen some information on not having exist I just need to compare two columns PrevMonth from EmpHist table and Currentmonth from Emp table and see what fields in Currentmonth from Emp table do not match or is null compared to PrevMonth column in EmpHist table...
  14. corbinap

    Comparing two columns in different tables

    How do I compare to columns in two different tables. By using Not in or Not Like. Can someone give me an example with two tables....Thanks.
  15. corbinap

    Month to 2 digits

    How do I convert the month to return a 2 digit month - not 1???? Declare @LastMonth varchar(2) SET @LastMonth = convert(varchar(2), Datepart(mm,getdate())-1); select @LastMonth
  16. corbinap

    Parameter macro

    I need a macro that is a parameter of 1 through 10 (or so), and for the parameter value, copy spreadsheet and clear which a user is not able to see. Does anyone have an example or could help show me how to achieve. Thanks
  17. corbinap

    Data Type error

    I am getting an Datat Type error. I think because the fields are text but I am not sure how to change to make work. Thanks in advance. Me.TempAssignedSalon.RowSource = "select SalonID from salon where salonid<>" ' & Me.cmbSalon
  18. corbinap

    Subform filter

    Yes - thank you. That is correct..

Part and Inventory Search

Back
Top