Report calculation..

[akumar118]

Friends,
I am developing a DAK management System.

I designed a table with fields viz. srno,date,disposed(Boolean)
I created a query which will ask for startdate and end date.

What i I am looking for :
a report showing the following

Outstanding letters (previous fortnight)
Receipt letters upto the date of generating
Total letters same as above
Disposed letters same as above
Balance letters same as above

The period is fortnightly.
i.e. from 1st to 15th and then from 16th to last day of the month

Can any one help me in this matter..

 

[vbaInet]

Without some template report it would be hard to see what you want to achieve. Draw up your plan in Word or something so we see a visual representation.

 

[akumar118]

Thanks that ws very fast,

I am developing a DAK MANAGEMENT SYSTEM, which would give you the position of all the letters received in the office. i.e. When was received, to whom was the letter given and the present status of the letter.

I have managed to develop a Data Entry screen on one single table i.e. LETTERMASTER.

The design is as follows:

Table

SRNo (Autonumber) No by which the letter shall be identified

From text Received from whom

Date_frm Date Date of the letter

Subject Memo Subject

To_whom_given text Officer to whom the letter is marked

Date_ given date Date on which the letter was given to officer

Disposal yes\no Whether disposed on not

Date_ of Disposal Date Date

File_No Text File number of the disposed letter


I designed two query which on the basis of two dates will show the outstanding letters and received letters.

Statement showing the position of letters received during the period 01-03-2010 but not disposed off by 15-03-2010

The following report should be generated on 16-03-2010

Now, in the report I used

?????????????? is what I need Closing balance of previous fortnight
Or opening balance as on 01-03-10
= COUNT([DISPOSAL]) gives Received letter

=COUNT(IIF([DISPOSAL]) = TRUE,0)) gives Disposed letter

=COUNT(IIF([DISPOSAL]) = FALSE,0)) gives Outstanding letter\Closing balance

If u need I shall send u the mdb file..

 

[vbaInet]

Have a look at these functions:

DLookup(), DateAdd() and DateDiff()

See what you can do with those.

 

[akumar118]

I shall try