Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / April 2005

Tip: Looking for answers? Try searching our database.

Columns with formulas...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sinex - 29 Apr 2005 07:41 GMT
Hi,
  Is it possible to have a formula in a column? Eg. I have three columns A,
B, C. I want the value of C to be the sum of A and B. How do I specify such
formulae?

...Sinex
tina - 29 Apr 2005 08:01 GMT
you don't enter calculations in table fields. normally, you also don't save
the results of calculations in table fields. instead, you save the raw data
in one or more tables, then create a calculated field in a query to display
the value, as

   C: A + B

hth

> Hi,
>    Is it possible to have a formula in a column? Eg. I have three columns A,
> B, C. I want the value of C to be the sum of A and B. How do I specify such
> formulae?
>
> ...Sinex
Stumped in New Hampshire - 30 Apr 2005 21:56 GMT
The best way to accomplish your goal is to place Columns
A and B into your table. Then, create a query with a
calculated column: For example,
TableNew
FieldA:
3
44
FieldB:
5
10
Now create a query that pulls both fields and place your
calculated field in the 3rd column of the query: Say for
example: MyCalcField:[FieldA] + [FieldB](This would be
typed into the top row of column 3 in the design grid of
the query exactly as above. When you run the query, each
row will calculate the MyCalcField value.It would look
like this:
FieldA     FieldB     MyCalcField
3          5          8
44         10         54
>-----Original Message-----
>Hi,
[quoted text clipped - 5 lines]
>
>.
 
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.