Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trouble with limiting results for a report

Status
Not open for further replies.

ISDConsult

Technical User
Sep 26, 2000
2
AU
We are a student group, and part of our project involves developing a report which includes counts of both genders, counts of 5 different age ranges, etc.
Our problem is that in the database we created, all of these things which we need counts of are in list boxes, Example: gender is a lict box of Male and Female. This in itself is not the problem, but the report calls for Males, Females, Under 18, 19 - 25, etc, all limited by date ranges. and we have been unable to get counts of each of these things at the same time inside the same query or report.
If anyone knows of a way to do this that we may not have thought of, or knows the simple little trick in MS Access that makes it possible, please let me know.
Thankyou,
Ben Kennedy [sig][/sig]
 
Ben:

When you say they are in list boxes do you mean that they are selected from list boxes on a form?

If so, I expect that they are being stored in atable or tables and what you need to do is set up queries that extract the data or data combinations that meet your criteria.

If you can provide some info on table structure and the criteria for your report needs I'm sure we can give better answers. [sig]<p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br> [/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top