Access report - create totals

Microsoft Access report used for stock take valuation. Report grouped by stock code. Need a calculated expression in stock code footer section, and same in category footer and report footer. Expression would be value from detailed section minus **sum total** from another field. The result of this calculation would then be used in the stock code footer section to multiply this value by the average stock price. This answer would only include values > 0. Also need filter to hide stock_code footer section if this result if zero. On report header I would like to display the date runtime query value. All dates are UK format (dd/mm/yy) Database is Access 2002. Would prefer solution without AccessVB code (so I can adapt it) but if there is no other way [url removed, login to view] ok. Would like project complete within 24 hours. Field details in stock code footer: SumTransQty = sum(TransQty) NetStock= QTY_IN_STOCK -(SumTransQty) Valuation = NetStock* AVERAGE_COST_PRICE Looks simple but is taking me ages to figure out...

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP Access 2002 UK date format (dd/mm/yyyy)

Skills: Engineering, Microsoft, Microsoft Access, MySQL, PHP, Software Architecture, Software Testing, Windows Desktop

See more: access create report, microsoft web expression, microsoft expression web, microsoft access web database, hire microsoft access, dd for hire, zero bid price, yy, desktop valuation work, create report database php, stock report, hours access database, section hide, access database work hours, access create query, database project microsoft access, expression access report, stock project access, work hours database access, microsoft access stock, access report code, php create report database, php report create, microsoft access complete project, create calculation web form

About the Employer:
( 1 review )

Project ID: #3920393

Awarded to:


See private message.

$42.5 USD in 1 day
(11 Reviews)

4 freelancers are bidding on average $38 for this job


See private message.

$42.5 USD in 1 day
(409 Reviews)

See private message.

$25.5 USD in 1 day
(303 Reviews)

See private message.

$42.5 USD in 1 day
(0 Reviews)