Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old December 20th, 2006, 01:45 AM
Registered User
 
Join Date: Dec 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creation of day Balances

Hello to all
help required on access reports
i have designed a small access database for my establishmnet.
contaning query DATA.
which as following fields, with data as shown
DATE VOUCHERNO CREDIT DEBIT
12/03/2006 3 10
12/03/2006 4 20
12/03/2006 5 40
12/04/2006 6 15
12/04/2006 7 30
12/04/2006 8 50

basing on this query, report should be generated showing Opening and closing balances day wise as shown below

Report
DATE VOUCHERNO CREDIT DEBIT
12/03/2006 OB 50 ------------------> previous day
12/03/2006 3 10 CB
12/03/2006 4 20
12/03/2006 5 40
                   CB 40
                            --------------------------
  Day Grp 80 80

12/04/2006 OB 40
12/04/2006 6 15
12/04/2006 7 30
12/04/2006 8 50
12/04/2006 CB 35
                            ---------------------------
  Day Grp 85 85


it runs for the whole month
OB, CB is not entered in table, it should be generated at runtime
OB should br carried forward from previous day
OB, CB should be generated while report is been previewed
Experts help is required in this

Thanking all in advance

civa
  #2 (permalink)  
Old December 20th, 2006, 08:44 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I personally would create a table to store this data, then run code to gather values for each day and make the calculations. Clear out the table before each run.

You could probably do a straight query to get the opening and closing balances each day, but not and hold the transaction values at the same time.

You could also create a report with the transaction in the detail sections, grouped by day, and then in the group header put the OB and CB using formulas in unbound text boxes.

HTH

mmcdonal
  #3 (permalink)  
Old December 22nd, 2006, 03:13 AM
Registered User
 
Join Date: Dec 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hii
 i have seen this type of report in vb, i think it can be done by report
coding some help is required on this type of report coding

civa

  #4 (permalink)  
Old December 30th, 2006, 05:46 AM
Registered User
 
Join Date: Dec 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Happy new year to all of u
   My report problem is not been solved. so please help me, whether
report requries any vb code inorder to generate the above report

thx to all
civa



Similar Threads
Thread Thread Starter Forum Replies Last Post
getting the same day of the week. crabjoe Classic ASP Basics 3 February 27th, 2008 12:45 PM
Day balances problems civa2006 Access VBA 1 January 11th, 2007 08:36 AM
how to get the day from a given date pherms Classic ASP Basics 2 April 16th, 2004 05:38 PM
day to day use of XML mano XML 1 November 27th, 2003 01:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.