MS Query Alias

[Dugantrain]

Hi, I'm trying to do something which seems really easy, but I'm just not getting it. I have Excel pulling from an external data source (ProTrack, for what it's worth) and I need to add a field which is not in the data source called "Status". This field will simply have the word "Open" in every single field. In the Access SQL that I'm used to, this is simple:

'Open' AS STATUS

But that doesn't work for MS Query. In fact, I've tried every possible combination of single quotes, double quotes, and parentheses, and it still won't alias this stupid field!

 

[Mark W.]

Try...

SELECT List.Fruit, 'Open' AS 'STATUS'
FROM `Book1`.List List

 

[Dugantrain]

I've tried that, but it's still not getting it. In fact, this is my SQL:

SELECT NEWCALL.SERIAL, NEWCALL.CUST_PROB, NEWCALL.CADPN, NEWCALL.C_STREET, NEWCALL.C_CITY, NEWCALL.C_STATE, NEWCALL.C_ZIP, NEWCALL.NSS_AREA, NEWCALL.C_CONTACT, NEWCALL.PHONE, NEWCALL.RC_DATE, NEWCALL.COMMENTS, NEWCALL.TARGET_ACTUAL_DATE, NEWCALL.TARGET_ACTUAL_TIME, NEWCALL.BO_UPDATE, NEWCALL.TERR_UPDATE, NEWCALL.CLOSED_DATE, NEWCALL.CLOSED_TIME, 'OPEN' AS 'STATUS' 
FROM BRIO.NEWCALL NEWCALL

But it's no good?!

 

[Mark W.]

Using the MS Query GUI what happens when you type 'Open' in the new column field. Once the 'Open' column button is created double-click it and enter STATUS in the "Column heading" field of the Edit Column dialog?

 

[Dugantrain]

Well,

'OPEN' AS """STATUS"""

will make the column heading show up as

"STATUS"

with double quotes around the word. I try to use less quotes, but it always errors. I can't believe how difficult this is!