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



Default adding unique formulas to fields 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
Formulas in Access Table? Ti1993 Databases 0 06-24-2014 07:06 PM
A table in MS Access with 13 fields - should I divide it into two or more tables? sami Databases 1 02-18-2014 07:06 PM
MS Access and Sql Server - unique index causes reverse cascading deletes on parent table.? Bobs Databases 0 12-12-2012 11:06 PM
Access 2007: ┐how to pull two fields from one table into a single field of another table? hesca_a4 Databases 1 09-27-2012 12:07 PM
Adding a autonumber to a field in access 2007 that already has other fields filled out? Unknown_User Databases 0 06-07-2012 11:39 AM