Search results for query: *

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...

I tried aliases and appending but as I roll to a different month and drop off a month, the data remains the same for the previous month/year selection.

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...

That worked fabulous! Now, how do you keep the Months from displaying in alphabetical order instead of chronological order?

Here's my SQL: TRANSFORM Count(CLng(NZ([txtSessionID],0))) AS txtSessionIDNew SELECT tblRatingValues.Rating, tblRatingValues.Value, Count(qryRateOverPlantCase.txtSessionID) AS Total FROM tblRatingValues LEFT JOIN qryRateOverPlantCase ON tblRatingValues.Rating = qryRateOverPlantCase.txtOverall...

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...