RE: Access a subtotaly

• Previous message: Simona: "Access a subtotaly"
• Maybe in reply to: Simona: "Access a subtotaly"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Zdar a silu Simona, dna 17.02.2003 si napisal(a):

> Zdravim
> jsem zacatecnik v Accessu a zajimalo by mne, jestli nekdo vite, zda je
mozne v
> query primo vyjet u neco takoveho, co dela Excel pri pokynu
data-subtotals. Mam
> to sortovane pod sebou. Uz jsem to zkousela pres to total pole, v design
view,
> ale kdyz tam k poli "castka" dam Group by "Sum", tak absolutne nic
neziskam. Uz
> to hledam nejakou chvilku, ale nic. Budu hledat dal, ale hlavne by mne
> zajimalo, zda je to vubec tam, jestli je to mozne to po Accessu chtit. 
> Diky
> S.

v query to asi nepude :-))
ak som ta spravne pochopil, zobrazit vsetky polozky 
a vzdy pri zmene v urcitom stlpci dat medzisucet (count or sum) inych
stlcov.
to uz musis zbehnut do sestav,reports ... tam sa to da a tie potom mozes dat
do excelu.
ale ak niekto vie ako sa to da v sql napisat dam sa poucit ....


s pozdravom
AleXXX
-- 

Remember: there are no strangers in the world,
only friends who have not yet met.

• Previous message: Simona: "Access a subtotaly"
• Maybe in reply to: Simona: "Access a subtotaly"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.6 : 17. 02. 2003, 13:59 CET