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 » Importing queries from 2003

	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:

Importing queries from 2003

Resolved · Medium Priority · Version 2007

ReplyMon 8 Jun 2009, 14:51Delegate Alan said...

Importing queries from 2003

Can I import existing queries from 2003 when I upgrade from 2003 to 2007?

For upcoming training course dates see: Pricing & availability

ReplyTue 9 Jun 2009, 06:46Trainer Rajeev said...

RE: Importing queries from 2003

Dear Alan

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

Please remember that you can open an earlier version database in Access 2007 and then choose Office button and save it as 2007 version.

This will ensure all your database objects get saved as 2007 version.

If you want only specific queries to be imported into Access 2007 then you can choose the External Data Tab on the Ribbon. Then in the Import group you can choose the Access button and import the objects from the relevant database.

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

Mon 15 Jun 2009: Automatically marked as resolved.

Access articles

· How To Use The New Navigation Form In Access 2010
· How To Create An Index Report In Access
· User-Proofing Your Access Database: Part 1
· Interested In The Golden Rules For Building Access Databases?
· MS Access can promote teamwork

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

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips

How Access Can Provide The Key To Successful Stock Management

For any business with a large quantity and/or variety of stock, understanding what is in stock, in what number and where to find it is essential. The answer to these issues of stock management is a database, and Microsoft Access is the ideal database solution for your company.

» Article: Access training london in

When is the next powerpoint question

» Forum post: Training

If you want to work with multiple images, you need to place each image in a new layer. One the images or colours are in a new layer it is like having a base image and then the other images are placed over the base image. Layer order can be changed by dr...