Solved

Create invoice in access 2007

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Column Layout in Access Xp VBA Report 3 19
backup programme - VBA 3 24
750W Power Box and 500W Power Box PC 18 20
SDD and HDD laptops 22 41
I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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 …
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

803 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