 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / February 2008formulas in a table
Can you enter a simple sum formula in a cell of a table? For example: =2+2 Whatever your question is, I think the answer is "no". You can display something like this in a query. TwoPlusTwo: 2+2  SignatureDuane Hookom MS Access MVP -- > Can you enter a simple sum formula in a cell of a table? For example: > =2+2 > Can you enter a simple sum formula in a cell of a table? For example: =2+2 No. What exactly are you trying to do? gls858 You do not store calculated values in a tabel. That would be redundant if you already have the data needed to perform the calculation stored. What happens if you change value one later? How does the table know to update the SUM? Would you really want it to recalculate all these values every time you open your table? This should be done in the form or report using an unbound text box... =[field1] + [Fiedl2] or as a caluculated field in a query... SumOfFields: [Field1] + [Field2] Rick B > Can you enter a simple sum formula in a cell of a table? For example: =2+2 Thanks Rick B, I always wonder how the calculation works in Access as I normally use Excel for calculations. Your suggestion on having an unbound box at the report works excellent at the report I'm working at. Thanks... kul > You do not store calculated values in a tabel. That would be redundant if > you already have the data needed to perform the calculation stored. What [quoted text clipped - 14 lines] > > Can you enter a simple sum formula in a cell of a table? For example: > =2+2 hi, access is not excel. what you are trying to do is an excel thing. you can put forumlas in a query and they are entered at a header and do the calculations on the records but you cannot put a fourmla in a table. >-----Original Message----- >Can you enter a simple sum formula in a cell of a table? For example: =2+2 >. Thanks. Unfortunately I'm trying to eliminate some "double entry" work on my end by not using excel. The data that I am working with is already in Access and just though if I could keep track of "fees" added to a client one cell it would be easier. > hi, > access is not excel. what you are trying to do is an excel [quoted text clipped - 6 lines] > For example: =2+2 > >. > Thanks. Unfortunately I'm trying to eliminate some "double entry" work on my > end by not using excel. The data that I am working with is already in Access [quoted text clipped - 13 lines] >> >>>. Like I said before, explain what you are trying to do and I'm sure someone here will help. It may as simple as adding a new field to a table. gls858 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.