Repost of Request for finding Averages with a query

J

Joe Cilinceon

What I'm looking for is an average (Monthly) for payment methods. For
example what percentage of payments for this month are in Cash, Check,
Credit Card, Money Order etc.

The Tables this is on are:

LEDGER
Transaction (to Payments.Transaction)
PaymentDate

PAYMENTS
Transaction
PayTypeID (1=Cash, 2=Check, 3=MoneyOrder, 4=Visa, 5=MasterCard)

tlkpPayMethods
PayTypeID (to Payments.PayTypeID)
PaymentGroup (1=cash, 2=check,3=MoneyOrder, 4=Credit Cards (both MC &
Visa)
 
D

David S via AccessMonster.com

Hi Joe,

I see this is a "Repost" - has your other post got an asnwer to this already?

It should be pretty simple to put together a monthly average of each payment
type - are you after an average of the number of types of each payment, or an
average of the value of each payment type?

Percentages are a separate issue, and this confuses me a bit - how do these
relate to the monthly averages that you're after?
 

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

Average Need on Payment Methods 5
Need A code for Visible/Hide base on Combo Box 14
Table Design Problem 1
Help with Payment Database 2
Questions On a Payment Ledger 0
Builing a query from selection criteria on a Form 1
populate a field 1
Help finding information on Database design 8

Top