Form Report

Seriously needing help on this.... Any kind soul who has a example plese email to mi @ ert_23@atozasia.com Thanks a lot........

I need something like this .....

Project Name:
xxxx
xxx
xxx

Staff Involved:
xxxx
xxxx
xxxx

Usage:
xxxx
xxxx
xxxx


Juz something like this ..... Will be glad if someone can explain how it works...

What do you need to look like this, a table and query that feed a report or a tabular spreadsheet?

btw -- please post assistance here so all may benefit from the efforts of the kind soul

______
Cheers!

If the 3 lists areindependent lists then just create a report with three subreports.

If the the second is a sub-list of the first meaning:

project name a
xxxxx
staff involved for a
********
**********
**********
usage for a
++++++++++++
+++++++++++

Project name b
xxxxxxxxx
staff involved for b
********
**********
**********
usage for b
++++++++++++
+++++++++++


Then write a query with all of the fields in it for the record source. then within the report create groups for project name and staff involved. Then be sure to create a group header for both, and place the controls for project name and
staff involved into the headers where applicable.

IT is derived from a form to feed into the report....

there will be 2 tables and i do not know how to implement it...

Are you saying you will use a form to let the user select what records he wants on the report? And what is the table format for the two tables?

It is a list which is derive from the database n later it is pass on to the Report later to print....


Tks for helping mi

As far as I can understand, that functionality exists directly in Access. Please help me understand where the VBA programming code is required. Otherwise, if it's just that you don't know how to make a report call data from two tables, set up a query to compile the data you need and use the query to supply the report.

______
Cheers!