Depositamount
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 23 articles for 0.302 sec
Thanks Mark...it does already contain information and I don't think I could send it...might get in trouble...confidenciality and all. But I fiddled and managed to create it without the old information. Can I import the old information into this new form? It will mean creating new transaction queries and reports ...alot of work. Any short cuts? I'm willing to do the work if there isn't     

Group: microsoft.public.access.forms · Group Profile · Search for Depositamount in microsoft.public.access.forms
Author: Gwendolyn
Date: Aug 21, 2008 06:45

If you want to email me the Database, I can take a look at it. My address is Mark A Sam Att M S N Dott Comm Remove the spaces, change Att to @ Dott to . and Comm to com. I think you understand why. Also change the database extension from .mdb to .mdx. I'll rename it when I get it. Otherwise I can't save it to my drive. God Bless, Mark "Gwendolyn" <Gwendolyn@discussions
Show full article (8.71Kb) · Show article thread
Hi Mark, I created the 2 tables as you suggested - well with Expensetype, withdrawlamount, depositamount, and Donation source in the subform table (I explained that poorly earlier). I changed Record source properties as you suggested. Unfortunately I get alot of blanks or error messages. And I don't see any of the data that I have put into the orginal form displayed at all. Good     

Group: microsoft.public.access.forms · Group Profile · Search for Depositamount in microsoft.public.access.forms
Author: Mark A. Sam
Date: Aug 20, 2008 14:46

I will definitely try this Mark! I'll let you know how it goes. God bless you richly! -- Gwendolyn "Mark A. Sam" wrote: It would help if you talked about tables instead of forms. I think you created the subform using the original table. If you have a form and subform, you need a table for each. From your description, the main table should have these fields:
Show full article (7.66Kb) · Show article thread
It would help if you talked about tables instead of forms. I think you created the subform using the original table. If you have a form and subform, you need a table for each. From your description, the main table should have these fields: TransactionID - This is an autonumber field - Field Size property is Long Integer TransactionDate TransactionDescription ReferenceType Number     

Group: microsoft.public.access.forms · Group Profile · Search for Depositamount in microsoft.public.access.forms
Author: Gwendolyn
Date: Aug 20, 2008 13:59

Hi Mark, Would it help if I explained it further? Original form (used for past 6 months) called Transactions TransactionID TransactionDate TransactionDescription ReferenceType Number AccountID ExpenseType WithdrawlAmount DepositAmount DonationSource MissionsDepartment Then I created a subform using the AccountID - MissionsDepartment and inserted it into the old Transaction
Show full article (6.67Kb) · Show article thread
Try as query like: SELECT [Job ID], [Customer ID], Quote * 0.1 As DepositAmount FROM Jobs; -- Duane Hookom Microsoft Access MVP "AJRoad" wrote: > The Quote field is the Customer's cost for the job. > > "Duane Hookom" wrote: > > > You are asking how to display a currency value but don't seem to have any > > fields in the table you described that store a currency value. I'm     

Group: microsoft.public.access.forms · Group Profile · Search for Depositamount in microsoft.public.access.forms
Author: Gwendolyn
Date: Aug 20, 2008 10:14

You're welcome, you're welcome:) "Charles" <Charles@discussions.microsoft.com> wrote in message news:034F3400-A105-4549-8204-C58627E12B3C@microsoft.com... This answer from Pat Hartment solved 2 days of looking for an answer. Thank you thank you. -- cjw "Pat Hartman (MVP)" wrote: The problem is probably caused because some rows have null values in DepositAmount
Show full article (5.77Kb) · Show article thread
This answer from Pat Hartment solved 2 days of looking for an answer. Thank you thank you. -- cjw "Pat Hartman (MVP)" wrote: > The problem is probably caused because some rows have null values in > DepositAmount or WithdrawalAmount. Duane's solution works because the > aggregate functions ignore nulls so sum(aa) - sum(bb) will work fine. In > other situations you may have to use     

Group: microsoft.public.access.forms · Group Profile · Search for Depositamount in microsoft.public.access.forms
Author: Mark A. Sam
Date: Aug 20, 2008 10:03

The problem is probably caused because some rows have null values in DepositAmount or WithdrawalAmount. Duane's solution works because the aggregate functions ignore nulls so sum(aa) - sum(bb) will work fine. In other situations you may have to use the Nz() function --> sum(Nz(aa,0) - Nz(bb,0)) -- notice that each operand in the expression must be cleaned of nulls. Nz(Sum(aa - bb)) will
Show full article (5.27Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Depositamount in microsoft.public.access.forms
Author: Gwendolyn
Date: Aug 20, 2008 09:39

Show full article (3.99Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Depositamount in microsoft.public.access.queries
Author: Duane Hookom
Date: Apr 26, 2008 15:15

Show full article (1.03Kb) · Show article thread
    

Group: microsoft.public.access.reports · Group Profile · Search for Depositamount in microsoft.public.access.reports
Author: Pat Hartman (MVP)
Date: Mar 22, 2007 06:35

Show full article (1.37Kb)
    

Group: microsoft.public.access.reports · Group Profile · Search for Depositamount in microsoft.public.access.reports
Author: Charles
Date: Mar 21, 2007 09:28

Show full article (1.17Kb)
    

Group: microsoft.public.access.reports · Group Profile · Search for Depositamount in microsoft.public.access.reports
Author: Pat Hartman (MVP)
Date: Feb 23, 2007 13:25

Show full article (0.99Kb) · Show article thread
1 · 2 · 3 · next