Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-17 : 09:08:41
|
JG writes "Dear Guru,
I need to build a report with ASP that will count all the patients fitting various criteria from an Access database.
The tables we have are patients, patient demographics, clinics etc. For example, I need to pull out a count of the number of patients fitting ie: ages 0 - 4, 5-10, 11-15 etc seen at clinic #1 (or 2 or 3).
This information needs to be displayed:
Ages Clinic 1 Clinic 2 Clinic 3 Total
0 - 4 15 10 5 30
5-10 5 1 10 16
etc.
How would this be done? Scripts were suggested.
Thanks for your time.
JG" |
|
|
|
|
|
ASP SQL Report