Hi,
I’ve created a MS Query in Excel, and I’m wanting to add a new column, not a column from the file I’m querying. For example, below is the data from the file, and the far right column (New Period) is the data I want to create with a formula:
Company Nature Period Amount New Period
75 4000000 JAN09 1,000.00 JAN09B
I want to define a new column (the New Period above), by putting a formula in the field heading area.
I’ve used formulas such as:
left(Period,3) and the result would be JAN, and this works just fine.
Unlike Exel, MS Query will not let me use the = sign. Likewise, it doesn’t like the & sign, which is what I tried to do by using this formula:
Period&”B” to create the New Period called JAN09B
Does anyone know how I could create this inside the MS Query, as opposed to having the formula in Excel AFTER the data has been downloaded. I’m trying to eliminate formulas in Excel, plus I’d simply like to know how far I can take the formula’s inside MS Query. I’d love to know if an IF Then formula inside MS Query works as well.
Any & all ideas are appreciated!
Thanks!!
Lana