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 » Append Query

	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:

Append Query

Resolved · Low Priority · Version 2003

ReplyTue 2 Jun 2009, 14:19Delegate Toby said...

Append Query

What is the append query used for?

For upcoming training course dates see: Pricing & availability

ReplyWed 3 Jun 2009, 16:33Trainer Rajeev said...

RE: Append Query

Dear Toby

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Append query is mainly used for copying and pasting records from one table to another. I believe the main advantage of using the append query is that you can set a specific criteria that it follows to append only specific records.

Please refer to the following link that provides you with more information about append query!!

http://www.databasedev.co.uk/append_query.html

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Wed 10 Jun 2009: Automatically marked as resolved.

Access articles

· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· Microsoft Access: Access Its Full Potential For Business Rewards
· Data validation in MS Access
· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· Easy Updating With Microsoft Access

Please browse our web site to find out more about
ms access 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

How do I create a milestone.

» Forum post: Milestone

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