Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

reports

ResolvedVersion 2003

Eddy has attended:
Access Intermediate course
Access Advanced course

Reports

Can you create a report from multiple tables or queries?

Edited on Tue 6 May 2008, 17:00

RE: Reports

Hi Eddy, Thank you for your post, welcome to the forum, I hope you enjoyed your course today; in answer to your question, because Access is a Relational, or Multiple Table Database, it works better when Tables are reduced to the highest level of Normalisation, (usually level 3) and then connected to each other using the Relationships window or within a query (for a temporary join), once your link has been created, you can create a report manually or using the Report Wizard, and extracting fields from multiple tables and/or queries as you require.
I hope that has answered your question, I look forward to seeing you on the forum in the future. Best regards Pete.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.