1405
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 5 articles for 0.235 sec
I think it could have worked out a lot better with Karl and Marsh's suggestion to use data stored in tables rather than hard coding values into an expression. What happens to this solution when Cost Types are changed? You shouldn't build expressions that might require maintenance in the future. -- Duane Hookom MS Access MVP "Warren Phillips" <WarrenPhillips@discussions.microsoft     

Group: microsoft.public.access.queries · Group Profile · Search for 1405 in microsoft.public.access.queries
Author: Duane Hookom
Date: May 13, 2010 20:09

Rick This could not have worked out any better. It worked out perfectly. Thanks to everyone for taking the time to help. "rbeach" wrote: You could use the formula below. This if the field are text. If they are numbers you will need to remove the quotes. E1: =Iif([Cost Type] = "L","1405",Iif([Cost Type] = "M","1410",Iif([Cost Type] = "S","1480",Iif([Cost Type] = "G","1495"
Show full article (2.07Kb) · Show article thread
Warren Phillips wrote: >I am trying to accomplish the following in a Microsoft Access 2007 QUERY. I >want to evaluate a field called "Cost Type" for the following values and then >populate a new field (E1) with a value based on the Cost Type. > >For example > >If Cost Type = L, populate E1 with 1405 >If Cost Type = M, populate E1 with 1410 >If Cost Type = S, populate E1 with 1480     

Group: microsoft.public.access.queries · Group Profile · Search for 1405 in microsoft.public.access.queries
Author: Warren Phillips
Date: May 13, 2010 11:25

You could use the formula below. This if the field are text. If they are numbers you will need to remove the quotes. E1: =Iif([Cost Type] = "L","1405",Iif([Cost Type] = "M","1410",Iif([Cost Type] = "S","1480",Iif([Cost Type] = "G","1495",Iif([Pay Item] = "955000","1490",Iif([Pay Item] = "955300","1491",Iif([Pay Item] = "955200","1492",Iif([Pay Item] = "955100","1493","") -- Rick
Show full article (1.54Kb) · Show article thread
高醫醫學研究所與東京大學醫研科橫山一成客座教授與美國CITY OF HOPE機構 (http://www.cityofhope.org/Pages/default.aspx)進行研究合作，目前該機構提供補助 研習JDP2相關技術的機會，名額只有1名，期間3個月~1年不等，並補助機票費及研習期間 之生活費，歡迎有興趣者踴躍提出申請！ 有意申請者請檢附下列資料 1.申請意願書(中英文各一份,兩頁以內)，說明內容如下，請以A4紙書寫。 (1)申請目的 (2)個人研究專長 (3)預期效益 2.中英文簡歷 3.指導教授英文推薦信一封。 意者請聯絡黃先生 kimi920@gmail.com Detail of applicants Applicants; Graduate student or Assistant professor (under 35).     

Group: microsoft.public.access.queries · Group Profile · Search for 1405 in microsoft.public.access.queries
Author: Marshall Barton
Date: May 13, 2010 06:50

Show full article (1.53Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for 1405 in microsoft.public.access.queries
Author: rbeach
Date: May 13, 2010 06:21

Show full article (1.31Kb)
    

Group: tw.bbs.sci.biology · Group Profile · Search for 1405 in tw.bbs.sci.biology
Author: ¤p¥i·R
Date: Jan 28, 2010 20:05

Show full article (3.11Kb)