Lonnie Johnson
prodevmg at yahoo.com
Mon Oct 13 16:10:07 CDT 2003
I'm sorry, then my question would be, "What are you prompting them for?". If your ranges to do overlap into other Area groupings, then what is the purpose of prompting for a center? Gina Hoopes <hoopesg at hotmail.com> wrote: I can't be explaining myself properly. My table of areas and center ranges is as follows: STALLWORTH - 1080400000 CHS - between "108175*" and "108176*" or like "40811*" VCHA - between "108100*" and "108210*" and so on ... If I am prompted for a center range and I tell it between 108100 and 108210 I'm only going to get VCHA. How would I get all of my areas and centers in the report using a parameter query? Lonnie Johnson [prodevmg at yahoo.com] wrote: That's exactly what I said. If you put the prompting criteria for the range in the query, they get prompted once. Then that record set is fed into your report where the grouping has already been pre-defined. Here in the report you an even have headers and/footers so that you may create totals, sums or any other aggregate function you desire. One query, one prompt, one report. I do it all the time. Why do you think you need many queries? _________________________________________________________________ Send instant messages to anyone on your contact list with MSN Messenger 6.0. Try it now FREE! http://msnmessenger-download.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? The New Yahoo! Shopping - with improved product search -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031013/e777060e/attachment-0001.html>