RE: Turnover query

Hi Mark,

I just sent you an e-mail with the database. Thank you so much for offering
to help! I'm somewhat new at Access and haven't quite figured it all out.
Thank you again!

Tandy

"Mark J" wrote:

if you can send me a copy , i should be able to work it out for you, much
easier when you have real data (markjankowski@xxxxxxxx)

"Tandy" wrote:

Hi Everyone!

I'm having quite the time putting together a turnover query, and am on my
second attempt. Right now I have three tables:
tblInsurance
InsuranceNumber (PrimaryKey)
InsuranceName

tblAccountsReceivable
ARID (PrimaryKey)
ARDate
InsuranceNumber
AccountsReceivable

tblCharges
ChargeID (PrimaryKey)
ChargeDate
InsuranceNumber
Charge

Then I have the following query:
qry1
InsuranceNumber
InsuranceName
ARDate
AccountsReceivable
ChargeDate
Charge

The tables are linked by InsuranceNumber. ARDate and ChargeDate are also
linked.

What I need is a way for my user to enter a beginning date, such as
12/1/2006, and then a report which calculates the turnover for the current
month and the previous eleven. Turnover is: (Current month Accounts
Receivable) / ((Current month and previous five months Charges)/182.5)

If anyone has any ideas of even a direction to pursue it would be much
appreciated. I'm just pretty stuck. Thank you!

Tandy

.

Relevant Pages

  • Re: Trading losses brought forward claimed against profits
    ... for these years I've been working out the accounts and filing the ... where the turnover was GBP 1500 and the gross profit GBP 1300. ... put the value into box 4 of the CT600 (Trading losses brought forward ... claimed against profits), so reducing the profits chargeable to ...
    (uk.business.accountancy)
  • Re: Sell The Tote off!
    ... If a private company did take over the TOTE, how long would it be before they started claiming they're a private company and have no loyalties to racing but to pay dividends to their shareholders? ... Their official accounts are horrific, apart from turnover, this must be the worst financial position in the history of the Tote taking the size of the market into account. ... It also mentioned a big drop of 2% in attendance in British race meetings last year. ...
    (uk.sport.horseracing)
  • Re: VAT bookkeeping
    ... >>> small company and having a look at the accounts section. ... > companies with a turnover of less than 150K GBP/A. ... > IIRC - the VAT is calculated on a percentage of t/o. ... > aggregation of individual VAT costs are not required. ...
    (uk.comp.os.linux)
  • Re: starting a small business in the UK to trade in Europe?
    ... turnover be taxed according to company tax in the UK or would the ... revenues pass through untaxed and I would then pay tax on them in the ... turnover, thus reducing the UK one's booked profits to almost nil? ... You'd have problems preparing the accounts without an accountant. ...
    (uk.finance)