0
The easiest way to do this, assuming you have a fixed tax rate, is to simple create a calculated field in a query.
Let's say you have a table with Price, Quantity, and TaxRate in it. Create a query based on that table, and bring these three fields into the query.
Now create a new, calculated query in a new column. In the first row (the name) of the query, put the following:
SalesTax: (Price * Quantity) * TaxRate
When you run the query, you should see SalesTaxt as a new, calculated field. Now you can use this query for any forms or reports you need this value in.
Hope this helps.
Richard Rost
www.AccessLearningZone.com
What else can I help you with?
How do you create a query using Microsoft Excel I need it for my ICT coursework and I can't figure it out any ideas?
You can search for something using Excel, but you would want to use Access to create a query. Please evaluate your requirements and ask the question again, using more specific terms of what you want to do.
What are the disadvantages of Microsoft PowerPoint to Microsoft Access?
SQL - Structure Query Language for MS Access is not as robust as you get on some other RBMS like MS SQL Server, Oracle etc. SQL gives you the flexibility of of data definition and manipulation using script. Pelumi (Nigeria)
What is show table in Microsoft Access?
Show Table allows you to display the structure of a table. In a query, you need to have at least one table, and using Show Table, you can pick the table or tables you need for that query. Once you've picked your tables, you can then choose the fields you need.
What skills are required in order to create a database using Microsoft Access?
To create a database using Microsoft Access, you need basic computer skills, knowledge of Microsoft Office and specifically, the Access application. You can learn how to create a database using Microsoft Access at the Office section of the official Microsoft website. Once on the page, type "How to create an Access database" into the search field at the top of the page and press enter to bring up the information.
Can you use SQL commands to modify queries created using the Simple Query Wizard in Access?
Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.Yes. Once a query has been created in Access, you can go to SQL View and make changes to it.
How do you get the sum and average on Microsoft Access?
You can do it through a query. If you click the SUM icon on the toolbar it will add a totals row to the design grid. Using it with any numeric fields you can get a query to do sums and averages. The totals row also gives options for other types of calculations. It is also possible to do calculated fields on forms and reports to get sums and averages.
My son's college class requires Microsoft Access How is this accomplished on a MacBook?
Microsoft Access is currently not available for Mac OS. You could try using BootCamp and installing Windows XP SP2 onto the MacBook and install Microsoft Access onto the MacBook using the Windows mode. There are other alternatives to Microsoft Access, which are designed for the Mac OS, such as FileMaker Pro. But if your son's college class requires specifically Microsoft Access, I suggest either using BootCamp to install Windows or using a Windows running computer/portable. If the requirement is only to read the Access data then Actual Technologies produce software to enable this (See links below) .
When using Microsoft access you select an entire record by clicking on what?
by clicking grey are on the left
What is the difference between sql and Microsoft Excel?
SQL means Structured Query Language. It is a programming language which is mainly used for maintaining databases. Excel is one of the application developed by Microsoft to do calculations, graphs using spreadsheets.
What are the advantages of using a validation rules?
The advantage of using validation rules in Microsoft Access is that you get clean and consistent data in your database.
What is a database query?
A database query is a piece of code (a query) that is sent to a database in order to get information back from the database. It is used as the way of retriving the information from databaseA database "query" is basically a "question" that you ask the database. The results of the query is the information that is returned by the database management system. Queries are usually constructed using SQL (structured query language) which resembles a high-level programming language.The term 'query' means to search, to question, or to find. When you query a database, your searching for information in the database. Different query languages exist for different type of databases. MS Access uses SQL, which stands for Structured Query Language. MS Access contains Tables, Forms, and Queries. The Forms are used to enter or display the data, the Tables are where the data is saved, and the queries are used to search for specific data.An example of an query can be this:SELECT DISTINCT Agent FROM QAMonitoring ORDER BY Agent;The query searches the 'Agent' field from the QAMonitoring table and sorts the list by last name. There are plenty of MS Access DB forums on the net for more info and help.Creating a Simple Query in Microsoft AccessHave you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.In this example, as with all of our Access tutorials, we will use Access 2000 and the Northwind sample database included on the installation CD-ROM. If you're using an earlier version of Access, you may find that some of the menu choices and wizard screens are slightly different. However, the same basic principles apply to all versions of Access (as well as most database systems).Let's explore the process step-by-step. Our goal in this tutorial is to create a query listing the names of all of our company's products, current inventory levels and the name and phone number of each product's supplier.1. Open your database. If you haven't already installed the Northwind sample database, these instructions will assist you. Otherwise, go to the File tab, select Open and locate the Northwind database on your computer.2. Select the queries tab. This will bring up a listing of the existing queries that Microsoft included in the sample database along with two options to create new queries.3. Double-click on "create query by using wizard". The query wizard simplifies the creation of new queries. We'll use it in this tutorial to introduce the concept of query creation. In later tutorials we'll examine the Design view which facilitates the creation of more sophisticated queries.
What is a querie is used for?
A brio query file - file extension bqy - is typically an sql query that can be connected to a RDBMS and return an answer or result set. A brio query file is created using Brio explorer or designer software. This sofware creates SQL queries using a graphic interface to render database objects that can be dragged and dropped on to the designer space. Query design is similar to MS Access.
