98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Reports
Reports
Resolved · Low Priority · Version 2003
Eddy has attended:
Access Intermediate course
Access Advanced course
Reports
Can you create a report from multiple tables or queries?
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |