database attached
Have attached the file. Please have a look.
I am presently working on Form 05....
thanks a ton...
User Profile
Collapse
-
5 mb approx...can i email it or is there a way such that all can see?Leave a comment:
-
-
what you are saying is logical as it would seem that :
anyway for each of the full set of criteria there can be only one answer, but obviously if there are 4 members access should understand that we are looking at the sum for all 4 and not merely the current record in that formLeave a comment:
-
My database is to help me arrive at the premium for an insurance plan
Premium depends on
1. Plan Type – Individual Plan
2. Insurance Co – Allianz
3. Plan Name – Health guard
4. Age – Age of that individual
5. Sum Insured – desired sum insured
Name Plan type Ins co Plan name Age Sum ins premium
Rahul Individual Allianz Healthguard 35 100000 2000...Leave a comment:
-
FORGIVE THE POOR NAMING OF THE TABLES FORMS ETC....
the dsum works but it gives me the total of the premium field only for the current record
DSum("[PREMIUM]","[10A tblTabularPremi um-Individual]","[10A tblTabularPremi um-Individual]![PLAN TYPE]=Forms![05 frmqryMainQuote - INDIVIDUAL]![06A tblSubQuotePlan-Individual].Form![PROPOSED PLAN TYPE - IND] AND [10A tblTabularPremi um-Individual]![INSURANCE...Leave a comment:
-
how do you get a sum of a dlookup control in the form footer?
=Sum(Dlookup(.. ..
does not work for me as the dlookup has 4 criteria and table has some 15000 lines, the sum(dlookup...) causes access to shut down, the dlookup however is working just fine.
Dsum on the other hand does not work as it takes the current record and gives me the total only of that one record.
No activity results to display
Show More
Leave a comment: