Develop report in MSAccess

  • Thread starter Thread starter Kutty
  • Start date Start date
K

Kutty

I have basic knowledge in MSAcess.
I would like to develop a software for report of purchase order. Just
assume the report will be single page or multiple page (depends on the
capacity of line number each time).
Fields will be as follows :
For each Purchase order in first page the details will be : date, to, from,
cash or check
Then I want type fields such as : item, description, unit_price, quantity,
total.

Once the page increase the 2nd page onwards will not display date, to, from,
cash or check. Continuation page number will be display, instead this
details will be per purchase order in first page. Please inform how to do
this in MSAccess.
 
First you need a table or query to hold the data you want in the report. Once
you build the table or query, click reports, then new. Use your report wizard
to create the report, picking the table or query you created. Then you can
open the form in design view and set up the properties.
 
I have created 2 tables as below fields :
Table 1: SN (auto number), date, from, to, cash/check
Table 2: SN (This has relationship to the above table)
item#(auto number), description, qty, mode of qty, unit
price, total price
Table 1 should display in first page per report.
In case there is multiple pages table 1 fields will come in first page only.
Once the items increase (I mean more than one page) table 1 will not come in
the remaining pages. I want table 2 in report under table 1. How can I do
this? Please help me.
 
Please let me know how to setup the properties. Please clarify if there is
more items to order how can I create multiple pages and not to mention date,
to, from,
cash or check
in continued pages except first page. How to do this.
 
Back
Top