. ,
, , , .
, Access , (. 14.23 14.24).
. 14.23. (TotalsByCustomer) ( ) . , Access , . 14.24
. . , , , , .
, . ( , , . .) , . , , .
. , . . . . , (Is
Hyperlink), , ,
. 14.24. CustomerPurchases . (="Products Purchased By " & [FirstName] & " " & [LastName])
, . Boutique Fudge ( ) , CustomerPurchases ( ) TotalsByCustomer ( ).
1. , , .
Totals By Customer.
2. , | → → (Report Design Tools | Design → Tools → Property Sheet).
|
|
3. , , .
(ID), . ID, . , , .
.
4. (OnClick). (...)
(Choose Builder) , , .
5. (Macro Builder) .
.
6. ,
. .
( ), .
7. , , .
CustomerPurchases.
8. (Where Condition) . , ID .
, . , ( CustomerlD CustomerPurchases), , ( ID TotalsByCustomers). :
[CustomerlD]=[Reports]![TotalsByCustomer]![ID]
, , Access , TotalsByCustomers.
9. .
, , , .
10. .
.
11. .
.
, .
V
Access