Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to calculate two or three fields within same table in Access 2007

Posted on 2009-02-22
9
Medium Priority
?
582 Views
Last Modified: 2012-05-06
Hello Experts,
This is my first time using access, and would like to create a formula (like the ones in excel)
i would like to add the cost field+ tax field and have it show up in the total field.
Is this possible?
0
Comment
Question by:pk24573
  • 5
  • 4
9 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 23704420
Hi pk24573,

If your form or report is based on a query then in the query add a new column Total:[Cost]+[Tax]
Then bring the total into your form/Report

Good Luck!

Gary
0
 
LVL 1

Author Comment

by:pk24573
ID: 23704465
Hi Gary and thanks for the quick response.

the form/table isnt based on  a query.

It's a simple form/table in which i enter customer details and at the end total value + tax.
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 23704490
pk24573,
So here beginneth the first lesson:

When you say form/table have you actually created a form?
If so ...go into properties & where it says Record source Click the dots....
So far so good?

Gary
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 1

Author Comment

by:pk24573
ID: 23704508
hi gary,

record source and properties of the table or form..because i dont see a record source in the properties of either...
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 23704542
Form - Properties - Data - Recordsource
0
 
LVL 1

Author Comment

by:pk24573
ID: 23706214
i found the record source, however, i think the record source is for the whole form..
is that correct?
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 1500 total points
ID: 23706699
Correct..now press the dots add a new column Total:[Cost]+[Tax].
Then add a new textbox to the form control source Total
0
 
LVL 1

Author Comment

by:pk24573
ID: 23709097
thanks i got it!!!
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 23709163
If you really "got it" & it works , then you should give an A
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question