Re: DCount Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Sun, 27 Nov 2005 10:31:20 -0600, Duane Hookom wrote:

> Again "Maybe you need to back up and tell us what you expect to accomplish."
> You seem to be divulging a bit of your needs at a time. It is very possible
> that our "bit" answers may lead you in the wrong direction. If we knew your
> current position and final destination, we might avoid some mistakes.

I am trying to create a small database for a medical charity, for which I
am not too brilliant at. Nonetheless, I think I have done a good job so
far.

One of the things they requested (right at the end) was whether they could
have a field on the main table indicating whether a member had paid or not
paid their membership. I did this with a drop down list (No/Yes). As you
know, it puts a 1 or a 2 (formatted as text) in the 'Payment Status' column
of the main table 'Clients'. There is also a text box on the main table
indicating the amount members paid in sterling (formatted as currency).
(The amount can vary). This is recorded in the 'Amount Paid' column on the
main table 'Clients'.

My query is this, if the is a value in the 'Amount Paid' column, then could
it be indicated in another form whether the member had paid/not paid?

On second thoughts, I think I will keep it as it is and leave the onus on
the charity office workers to do the recording, as there might be problems
when annual membership subscriptions are due for renewal?
.

Relevant Pages

  • Re: DCount Problem
    ... I would not keep payment information in the main table. ... every member should create a record in the related table. ... > paid their membership. ... This is recorded in the 'Amount Paid' column on ...
    (microsoft.public.access.gettingstarted)
  • Mid-Event Changes to 2005-06 NAP Conditions of Contest
    ... 6.A player whose membership dues are paid at or prior to the unit ... ONLY PAID MEMBERS, INCLUDING LIFE MASTERS WITH LIFE MEMBER STATUS,WHOSE ... DUES OR FEES ARE CURRENT AT THE UNIT STAGE AND BEYOND WILL BE ELIGIBLE ... Clearly implying that any LM who refuses to pay LM service fee, ...
    (rec.games.bridge)
  • Re: Mid-Event Changes to 2005-06 NAP Conditions of Contest
    ... > competition is deemed to be a paid member at the time of entry. ... > ONLY PAID MEMBERS, INCLUDING LIFE MASTERS WITH LIFE MEMBER STATUS,WHOSE ... ONLY PAID MEMBERS,INCLUDING LIFE MASTERS WITH LIFE MEMBER ... > Clearly implying that any LM who refuses to pay LM service fee, ...
    (rec.games.bridge)
  • Re: Freemasons and phone hacking?
    ... officers with people from NI alone, ... whether or not they are a member of a secret organisation, ... door neighbors line so he could get free calls? ... no next door neighbours at the Inn and I paid for three lines plus ...
    (uk.local.southwest)
  • Re: Freemasons and phone hacking?
    ... officers with people from NI alone, ... whether or not they are a member of a secret organisation, ... door neighbors line so he could get free calls? ... no next door neighbours at the Inn and I paid for three lines plus ...
    (uk.local.southwest)