How do I track daily sales against what I have?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Straw Man: data validation against a secured SQL Server db over a VPN tunnel 12
track daily sales 1
Apply Pament to invoices in form 0
Data collection 1
Rank a Rank? 1
Managing Ticket Sales 1
Ranking based on two criteria 3
Dollar sales by salesperson 6

Back
Top