RE: Summing a sum2:David S

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

Actually, David, there is a problem with AllBucksByFamily. If there are no
FamilyBucksUsed then FamilyBucksAvailable is blank even if there are
FamilyBucksEarned. Meaning that FamilyBucksAvailable should be the same in
this case as FamilyBucksEarned.

I've been spinning in circles and can't seem to fix it. I'd appreciate help
if you have time. Thanks.

"David S via AccessMonster.com" wrote:

> >As a last Bucks query question (I hope!), on ITABucksByContact query I'd
> >like to add together Bucks Earned and Bucks Used (because I think I'm going
> >to end up cashing in Bucks per Individual...). This is the part that was so
> >difficult for me. Thanks.
>
> Um, I'm pretty sure that's what the BucksAvailable field in the
> AllBucksByFamily query in my earlier post does...
>
> Glad to be have help, Stephanie - cheers!
>
>
> --
> Message posted via http://www.accessmonster.com
>
.

Relevant Pages

  • RE: Summing a sum2:David S
    ... "David S via AccessMonster.com" wrote: ... >>As a last Bucks query question, ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: Summing a sum2:David S
    ... As a last Bucks query question, on ITABucksByContact query I'd ... > AllBucksByContact.BucksUsed, AllBucksByContact.LastName, AllBucksByContact. ...
    (microsoft.public.access.queries)
  • RE: Summing a sum2:David S
    ... >Here's my ITABucksByContact query (using Amount as the alternate Bucks ... >FROM PaymentTypes INNER JOIN ((DuesItemType INNER JOIN (Contacts INNER JOIN ... PaymentTypes table, which is not such a good idea - if the Payment Type ...
    (microsoft.public.access.queries)
  • Re: Open a form from a record in Querry result or Table
    ... David assume for our discussion that you have a form and it is set to ... datasheet view and this form is based on the select query you mentioned ... the first form so that it opens your tab form and only display the one ... Private Sub Form_DblClick ...
    (microsoft.public.access.gettingstarted)
  • Re: ADVANCED: Suppressing "Save Layout?" dialog on form close
    ... I have the "Allow Design Changes" property set to ... Since the fields inside the query always load with the same width, ... OnUnload events both on the query's datasheet and the form but when the ...
    (microsoft.public.access.formscoding)