Solved

Create invoice in access 2007

Posted on 2009-04-05
3
4,199 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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
You have seen this as an option on your internet browser before or it may be completely new to you.  But what does this mean and why would I use this?
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 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

11 Experts available now in Live!

Get 1:1 Help Now