The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Making a table from a query which involves the calculation of tw

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Making a table from a query which involves the calculation of tw

Resolved · High Priority · Version 2007

ReplyThu 25 Feb 2010, 15:06Delegate Phylicia said...

Making a table from a query which involves the calculation of tw

Hi,

I have created a table to hold data on Gift Aid Income and would like one of the fields to automatically calculate the Gift Aid Amount shown as 20/78* [Donation]. I have created a query to do this, which works, however I am unable to make a table from this query. I would also like to be able to make the results in the form of currency, which will be shown in a form.

Please advise as to a possible solution.

Many thanks

Phylicia

For upcoming training course dates see: Pricing & availability

Access articles

· How To Import Data Easily Into Access 2010
· How To Find Good Access Database Courses In London
· Different Ways To Use Forms In Access 2007
· The Easy Way To Get Started With Access
· How To Sort And Filter A Table In Access 2010

Please browse our web site to find out more about
microsoft access advanced training and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions