General discussion

Locked

SUM and % in a MS ACCESS Report

By ora114 ·
Big trouble, Please help.
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums