nancybrown
Well-known Member
- Joined
- Apr 7, 2005
- Messages
- 868
I have an IF statement I am using in Excel to compare two columns of information: A = 2008 Term against B = 2009 Terms. I have a third column where I put the following formula:
=If(A2=B2,"Updated") It works great in Excel. The problem I have is that the file that I update regularly in Excel is very large and there's a lot of manipulation each time; I want to move it to Access. Will this IF statement work in a query in Access??? I presented a couple questions expressed two different ways the Access portion of Mr. Excel, but haven't gotten any hits yet . . . thought maybe I'd try the excel experts.
Help is much appreciated.
=If(A2=B2,"Updated") It works great in Excel. The problem I have is that the file that I update regularly in Excel is very large and there's a lot of manipulation each time; I want to move it to Access. Will this IF statement work in a query in Access??? I presented a couple questions expressed two different ways the Access portion of Mr. Excel, but haven't gotten any hits yet . . . thought maybe I'd try the excel experts.
Help is much appreciated.