reports

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

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

Reports

resolvedResolved · Low Priority · Version 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.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Server loaded in 0.09 secs.