Lonnie Johnson
prodevmg at yahoo.com
Mon Oct 13 14:10:57 CDT 2003
Use the report's Sorting and Grouping properties to do the "Grouping by Area". Create a query as the underlying record source for the report and set the prompts for the criteria in there like below: Between "*" & [What is the start of the range?] & "*" AND "*" & [What is the end of the range?] & "*" Gina Hoopes <hoopesg at hotmail.com> wrote: I need to build a report that uses a table for grouping criteria. The table has two fields, Area and CenterRange. So, Area might be ESKIND LIBRARY and the CenterRange is between "108694*" and "108699*". I need my report to Group by each area and use the CenterRange as the criteria. I'm using a DLookup but everything I'm trying fails. Can someone give me a direction on this? Thanks, Gina _________________________________________________________________ Help protect your PC. Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 _______________________________________________ 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/411f088e/attachment-0001.html>