Recent content by melissafvoelker

huh? okay, i kinda get it but why would someone want to do a union? Why someone would want all that data mixed up into one column is beyond me.

I would like to know the difference between these two concepts. Would anyone care to explain it to me?

I don't understand these two concepts. Would anyone care to explain it to me?

Access vs. SQL yeah. i realized it, but i thought the as was optional.

SELECT [asset class] , iif(ct2.[asset class]='3050', 'yes', 'Nope!') IIF_Example FROM CONVERSION_TABLE_2 AS ct2; The above isn't working because of my attempt to name the column. I want to call the column "IIF_Example." Why doesn't it work? Thanks

Table Issue? Hi, Thanks! I think that I was trying to add data to a table that was "locked" is that possible? because when I tried in on another table, it worked fine.

SELECT Conversion.[Asset Class], iif([asset class]<4000, "1", "2") FROM Conversion;

Thanks! thanks jon for your help. I finished the query it turned out great. Take Care! :)

SELECT [FA Ctr], [SAP Co], [SAP Ctr], [GL Co], Format (([SAP Co],"0000") AS NewField), (([cst ctr], "0000000000") as costcenterappended) INTO [Interim Table] FROM Asset_Map;

More help requested help i am having trouble with multiple format statements (i am not completely helpless, but there is definitely room for improvement) SELECT [FA Ctr], [SAP Co], [SAP Ctr], [GL Co], Format([SAP Co],"0000") AS NewField, format([cst ctr], "0000000000") as cost center appended...

thanks so much to both of you for your help. jon i tried what you suggested and was able to join the tables. Thanks so much!

i am trying to do an update query, but it keeps saying that zero records will be updated. It is also prompting me for parameters and i don't know why. here is the sql view. UPDATE Asset_Map SET Asset_Map.[SAP Co] = '0' WHERE (((Len([a].[sap co]))=3));

how do i set the field format to '0000' (without the apostrophes).

hi again. i used the following (what you suggested) but got an error message. SELECT a.[FA Ctr], a.[SAP Co], a.[SAP Ctr], a.[GL Co], IIf([Len([SAP CO])] =3,'0' & [a].[SAP CO], IIf([Len([SAP CO])]=2,'00' & [a].[SAP CO]), IIf([Len([SAP CO])]=1,'000' & [a].[SAP CO]", "[A].[SAP CO]"))) AS Expr3...

iif syntax hi Thanks a lot for your reply. I am trying to change the data in an existing table by using iif and making a table so i can join it to another table which has a text field that has leading zeroes. am i doing this right?