Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Create invoice in access 2007

Posted on 2009-04-05
3
Medium Priority
?
4,956 Views
Last Modified: 2013-11-29
I'm trying to create an invoice report in Access 2007 based on a union query, any template available please?
0
Comment
Question by:Touy
[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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 24074427
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
0
 

Author Closing Comment

by:Touy
ID: 31566845
Thanks. And thanks again for taking care of most of my questions.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24082748
;-)

I was up late anyway.
;-)

jeff
0

Featured Post

Visualize your virtual and backup environments

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.

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…

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.

Join & Ask a Question