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!

Register Log in
  • Congratulations IamaSherpa 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: *

  • Users: doloresmeehan
  • Order by date
  1. doloresmeehan

    including a subreport field in a calculation

    Hi there, I am trying to include the value in a subreport in a calculation on the main report. Can this be done? Thanks, Dolores
  2. doloresmeehan

    Removing embedded symbols

    Awesome - it worked. Thanks Guys! I did change the field type and then the replace script worked. Thanks again to you both.
  3. doloresmeehan

    Removing embedded symbols

    So, I ran this script: update snote set sNoteText = replace(sNoteText,'~','') where charindex('~',sNoteText) > 0 And received this error: Msg 8116, Level 16, State 1, Line 1 Argument data type text is invalid for argument 1 of replace function. Please help - did I do it right? Thanks
  4. doloresmeehan

    Removing embedded symbols

    Thanks for your help. Here's a sample of the data in one record (snoteText) of the table sNote: "SATIN PILLOW CASE SET;;FABRIC: 200T-210T 100%POLYESTER SATIN WEAVE, 75DX100D, SOLID COLOR;;~;~STYLE: 2"" HEM OPENING, DOUBLE STITCHING.;;LABEL: CARE LABEL;PACKING: VZB+INSERT; 6 PCS PER CARTON...
  5. doloresmeehan

    Removing embedded symbols

    Hi, I am trying to remove the ~ symbol that is embedded from a large text field. Is there a way to do that? Thanks, Dolores
  6. doloresmeehan

    combining records lines in Access

    Thanks Duane,
  7. doloresmeehan

    combining records lines in Access

    Hi, I am trying to combine text values in Access. The source data looks like this: item ID sequence text 00356 001 pillow with lace edge 00356 002 that has white little flowers What I need to see is: ItemID Text 00356 pillow with lace edge that has...

Part and Inventory Search

Back
Top