I'm trying to use dsum to calc values for regions in a report.
Every time the region changes, I need to get suumary values for that
region
This code works for one region
=DSum("mtd_ty_ret","qry_mtd_flash","reg = 'WEST' and div = 'BEBE
SPORT'")/DSum("st_area","qry_mtd_flash","reg = 'WEST' and div = 'BEBE
SPORT'")
but the hardcoded region name makes it work for only one region. How
can I code this with a variable in place of the region name,
here 'WEST'
the format of the report is like this:
store
district
region
store
district
region
store
district
region
Multiple store for each district
Multiple districts for each region
and summary totals for the entire company
Thanks
JPS
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
