Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access views

	98.1 % recommend us
	More live stats...

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

Training information:

Access views

Resolved · Low Priority · Version 2007

Reply Wed 29 Sep 2010, 16:38Delegate Graeme said...

Graeme has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Access views

Afternoon.
Do you know how I can view two tables of queries next to each other, like one can in Excel or Word?

For upcoming training course dates see: Pricing & availability

Reply Thu 30 Sep 2010, 11:32Trainer Newson said...

RE: Access views

Hi Graeme

Yes you can get the windows back. You need to turn it on for the database.

You need to click the Microsoft Office button and select Access Options

Then select Current Database halfway down to Application Options

There is a document windows options

Select the radio button which states overlapping windows.

You will need to close down the database and reopen it.

In the Home tab you will see a Windows group that will allow you to switch and tile different windows.

Thanks

Newson

Reply Thu 30 Sep 2010, 11:32Trainer Newson said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 7 Oct 2010: Automatically marked as resolved.

Access articles

· Up The Professionalism Of Access Files Thanks To Digital Signatures
· Understanding Primary And Foreign Keys In Microsoft Access
· How To Create An Index Report In Access
· How To Understand Access As A Relational Database
· Getting To Grips With Templates In Access 2007

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