How do I track daily sales against what I have?

M

Ms Lady Luck

I deliver newspaper to stores and I want to track their sales against what I
am leaving them. I want to know the percent of sales.
 
J

John Vinson

On Thu, 24 Feb 2005 18:17:02 -0800, Ms Lady Luck <Ms Lady
I deliver newspaper to stores and I want to track their sales against what I
am leaving them. I want to know the percent of sales.
Click to expand...

If you wish to do so in Microsoft Access, you'll need to create a
Database with at least two tables - customers and a table with fields
for the customerID, date, delivery count, and salse count; or three
tables, customers, sales, and deliveries. A Totals query or a query
with a calculated field will let you calculate the percentage.

John W. Vinson[MVP]
 
Top