can Access handle these 3 formulas?

[seanh1016]

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)

 

[Norie]

sean

I think, but not 100% sure, that Access could handle this.

Perhaps if you could explain exactly what you want do?

 

[seanh1016]

Trying to sort names. Here's the related post:

http://www.mrexcel.com/board2/viewtopic.php?p=869489#869489