Solved

Create invoice in access 2007

Posted on 2009-04-05
3
4,109 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
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
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
Comment Utility
Thanks. And thanks again for taking care of most of my questions.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
;-)

I was up late anyway.
;-)

jeff
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
How can this article save you time AND money?  In just a few minutes you may discover something you didn't know existed that is easy enough for you to fix yourself!
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now