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 Chriss Miller 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: techgirl10
  • Content: Threads
  • Order by date
  1. techgirl10

    Extracting Data From a Text String

    I have a bunch of data in a field that I need to extract into 3 different fields named: thickness, width and length. For example, with this text string: 025PC.080X12.0X12.0 I want to extract .080 = thickness, 12.0 = width, and 12.0 = length and plug that data into their respective fields...
  2. techgirl10

    Renaming Fields in SQL

    I have a query that I run monthly that contains a rolling 18 months of data. Therefore, the oldest month will drop off and a new month will be added so the months and years will change. I want to rename the fields a generic name such as Month1, Month2, etc. Can I do this in SQL? This is my...
  3. techgirl10

    Forcing Column Headings with Null Values Not to Display in Crosstab

    I am trying to show a rolling 18 months in my report. This will change monthly. I have two crosstab queries created for 2006 and 2007. I have them joined together in another query. There will always be 6 months without values between those two queries. Is there in any way in a crosstab...

Part and Inventory Search

Back
Top