Automatting invoices. Excel or access?

  • Thread starter Thread starter Arvin Meyer
  • Start date Start date
A

Arvin Meyer

Sounds like an Access report is just what you need.

Excel is the product to use when you are analyzing data or checking what if
scenarios. It is also outstanding for charting, and can display data for a
single dataset nicely. Access is the tool of choice for reporting. Since
invoicing is a reporting task, it is better handled in Access. BTW, the 2
systems do work together very nicely.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Aardvark said:
Hi all,

I want to set up an invoice system in which I can put the persons name and
the other details (Address etc) are automatically added. Ideally the
information would then be automatically copied to another worksheet for
subtotalling. Is this better done in access or Excel?

Thanks

Aardvark
Click to expand...
 
Hi all,

I want to set up an invoice system in which I can put the persons name and
the other details (Address etc) are automatically added. Ideally the
information would then be automatically copied to another worksheet for
subtotalling. Is this better done in access or Excel?

Thanks

Aardvark
 
Back
Top