About Manish Batola Expertise ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions and many more being added every year.
Experience 25 yrs in the Software industry with 19yrs completely dedicated on more than 250 Various Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.
Organizations Worked in various multinationals catering from Aerospace, Oil & Gas etc.
Question I have a report, i have to draw horiz. and verti. line AFTER DETAILS SECTION, upto end where i put sum total of a number field.
how ?
thanks
Answer Hi Hasmukh,
You need to create a Group on any of your fields with a Header and a Footer. You need to then place your complete line in the footer of the field you created a Header. This way your line will not appear in the detail section but only at the end of the total sum which I assume you will have in your report footer.