Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
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
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Suggested Courses
Course of the Month8 days, 16 hours left to enroll
604 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.