Help to design 40 reports.

[MikeN]

Hello,
Could your guy help me to design this kind of report.Thank
you.
My boss told me he need a report for 40 client with each
quarter for every year (from 2000 to 2003). I created a
mainmenu with combobox to do this? And Do I have to create
160 queries and 160 reports? And in every report he need
calculate like format below:

Client 1 - First Quater Year 2000

Gender
Male: # of male
Female: # of female

Age
<18: # of patient age less than 18 year old
19-29: # of patient age between 19 to 29

29: # of patient age >29

I have a table contain all this info. with char field.
How to do this?
Best regards.
MikeN

 

[Duane Hookom]

If your data tables are properly normalized then this should be only one
report with one or more subreports. If you look at the sample Northwind.mdb,
you will notice there isn't a separate invoice report for each invoice
number. There are many methods of setting a criteria on a report's record
source so that only a limited number of records are displayed.

 

[Perlith]

How familiar are you with:
-Databases in general
-Microsoft Access
-Visual Basic

That will help those reading this post in answering. The answer will be
complex no matter how it is approached, but it will help cut down the number
of approaches that could be taken with this problem.

 

[MikeN]

-----Original Message-----
How familiar are you with:
-Databases in general I am a MS Visual FoxPro guy
-Microsoft Access

I know a little bit how to create a form-Macro is bad one!

-Visual Basic

I know a little bit how to write VB code

 

[Duane Hookom]

Check Help for information on Queries and Criteria. There is a lot of
information about limiting reports/queries to a specific group of records.