Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
COURSE of the MONTH
11 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Create invoice in access 2007
Posted on 2009-04-05
I'm trying to create an invoice report in Access 2007 based on a union query, any template available please?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Touy
If you just need a report, you don't really need a template, just use the report Wizard.
Create-->Reports-->Report Wizard.
Select your Union query as the Query (source) and follow the wizard's prompts.
It will lead you through all the Report Options.
;-)
Template are for entire databases, not just reports.
If you need an "example" of a basic Invoice you can view one in the old Northwind sample Database:
http://www.microsoft.com/downloads/details.aspx?familyid=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=en
There is also one in the new Access 2007 Northwind sample database as well, but the database is much more complex.
http://office.microsoft.com/en-us/templates/TC012289971033.aspx?CategoryID=CT102115771033
I'm sure that this will get you what you are after.
;-)
JeffCoachman
If you just need a report, you don't really need a template, just use the report Wizard.
Create-->Reports-->Report Wizard.
Select your Union query as the Query (source) and follow the wizard's prompts.
It will lead you through all the Report Options.
;-)
Template are for entire databases, not just reports.
If you need an "example" of a basic Invoice you can view one in the old Northwind sample Database:
http://www.microsoft.com/downloads/details.aspx?familyid=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=en
There is also one in the new Access 2007 Northwind sample database as well, but the database is much more complex.
http://office.microsoft.com/en-us/templates/TC012289971033.aspx?CategoryID=CT102115771033
I'm sure that this will get you what you are after.
;-)
JeffCoachman
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month11 days, 3 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.