microsoft training access course - access
Request a callback

We'll call during UK business hours

0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Access

microsoft training access course - Access

resolvedResolved · Low Priority · Version Standard

Thu 26 Apr 2007, 12:02 replyReply Delegate Yasmin said...

Yasmin has attended:
Access Introduction course
Access Intermediate course


I have two similar queries reporting different sets of data.
I want to present or display the results on one report. Please advise how I can do this.

For upcoming training course dates see: Pricing & availability

Thu 26 Apr 2007, 13:03 replyReply Trainer David said...

RE: Access

Hi Yasmin

I hope you are enjoying access now that you have completed two of our three Microsoft Access courses.

There are two methods to solve your problem. The first is to create a new query that contains all of the fields from the original queries. The second option is when you create your report, you can bring data into it from both the queries.

The best way of achieving this, is to create the report in design view, that way you can place the data items where you want them to appear, then this will repeat for each row.

Hope this helps



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

Access training London
Course rating
4.8 stars - based on 4543 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom