Reply
Old 06-24-2014, 06:06 PM   #1 (permalink)
 
Status: Junior Member
Posts: 4



Default formulas in access table

I am trying to convert an Excel database into Access, and I have a column in excel that is calculated based on a formula, but the formula is different in each row.

I was wondering if there was a way to do this in Access, and to be able to see the actual formula.



Ex.
Excel:
Cell E2 = A2*(4*20+5)*1.05
Cell E3 = A3*5*20
Cell E4 = A4*12*20*1.05

How would I have something like this in access.

Thank you in advance.
Ti1993 is offline   Reply With Quote

Reply

Bookmarks

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding unique formulas to fields in Access Table? Ti1993 Databases 0 06-24-2014 10:06 PM
What is the correct formulas for these Microsoft Access Database Queries? James Databases 1 02-09-2014 03:06 AM
how can i convert excel (with formulas) to a webpage that calculates same formulas? leelouderback Programming 0 09-26-2013 10:07 PM
MS Access: Query Access table and Oracle table in one sql statement? Jay Oracle Databases 2 10-18-2012 08:09 AM
Create formulas in Access Tables? Unknown_User Databases 0 04-17-2012 10:37 AM