I am a beginner with Access.
I have 157,000 rows of data in one column only in a table in Access, let's call it column "C."
Can Access handle or convert these three formulas?
column A: =if(b1=0,0,sum(b1:$b1))
column B: =if(right(C1,5)="Name:",1,0)
column C: data
column D: =vlookup(a1,column C data,3,0)
I have 157,000 rows of data in one column only in a table in Access, let's call it column "C."
Can Access handle or convert these three formulas?
column A: =if(b1=0,0,sum(b1:$b1))
column B: =if(right(C1,5)="Name:",1,0)
column C: data
column D: =vlookup(a1,column C data,3,0)