can Access handle these 3 formulas?

seanh1016

Active Member
Joined
Feb 16, 2003
Messages
253
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)
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
sean

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

Perhaps if you could explain exactly what you want do?:)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,083
Messages
5,570,118
Members
412,305
Latest member
Mozz
Top