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 bkrike 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: expensive
  • Content: Threads
  • Order by date
  1. expensive

    Convert value to HTML

    Hello I've got a query which creates a URL address by prepending and appending a value. Nothing shocking so far, but the field is returned as a text datatype. How would I go about making the value return as a working HTML URL? I guess I'm looking for a way for Access to recognise that if a...
  2. expensive

    Request Help Removing "Special Characters" from fields

    Hello I'm struggling to work out how to remove all non-alphanumerical characters from a given field(s). I can do one at a time, SELECT REPLACE(field, 'value to replace', 'what to replace with') FROM tbl But I need to do this for all non-alphanumerical characters, including spaces. Can anyone...

Part and Inventory Search

Back
Top