General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SUM and % in a MS ACCESS Report
My Tables:
Table 1:CITY_TYPE, DISTRICT, CITY_NAMES, SHOPS, AREAS
Table 2: OPENING_TIME, CLOSING_TIME, AREAS
Table 3: DISTRICT, CITY_TYPE
I need to have a report:
CITY_TYPE,DISTRICT,CITY_NAMES,SHOPS, AREAS
,OPENING_TIME,CLOSING_TIME
with a total of city_type,city_name,shops, OPENING_TIME, CLOSING_TIME with a % of a category of shops
2nd rprt: DISTRICTS,CITY_TYPE and %CATEGORY OF SHOPS with OPENING_TIME, CLOSING_TIME
3rp: District, a %of category SHOPS with OPENING_TIME, CLOSING_TIME.
dATA: city_type: kolia, fijns,asers, bsiud
districts: kolia2,finjs3,aser4 (1 district may have 3 city_type) 1 city_type may have 6 city_name, 1 district may have 4 or more shops
shops: activa,nonman,offoi,nonres,
city_name
opening and closing time is 4/09/2004 3:20:09