شرط في دالة الجمع Dsum

[kaser906]

4 ساعات مضت, jjafferr said:

وعليكم السلام

 

المفروض يكون عندك استعلام عام ، واستعلام تجميعي يكون فيه البيانات المطلوبة:

.

 

جعفر

779.1.QryVisitors.accdb.zip

أذا ليس لها حل لظهور المجموع بنفس الاستعلام

أشكرك أستاذ على سعة صدرك وتحمل

رحم الله والديك

[jjafferr]

السلام عليكم

 

انا قلت "المفروض" ، وما قلت ما يصير !!

5 ساعات مضت, jjafferr said:

المفروض يكون عندك استعلام عام ، واستعلام تجميعي يكون فيه البيانات المطلوبة

 

الاستعلام اصبح:

SELECT Tabil_Visitors.id_visitors, Tabil_Visitors.Num_brnamge, Tabil_Visitors.service, Tabil_Visitors.Travel2, Nz(DCount("[Travel2]","Tabil_Visitors","[Num_brnamge]=" & [Num_brnamge] & " and [Travel2]=" & 1),0) AS Expr1, Nz(DCount("[Travel2]","Tabil_Visitors","[Num_brnamge]=" & [Num_brnamge] & " and [Travel2]=" & 2),0) AS Expr2, IIf([Travel2]=1 Or [Travel2]=2 Or [Travel2]=3 Or [Travel2]=6 Or [Travel2]=7 Or [Travel2]=8,Nz(DCount("[Travel2]","Tabil_Visitors","[Num_brnamge]=" & [Num_brnamge] & " And [Travel2]=" & [Travel2]),0),0) AS Expr3, IIf([service]=1 Or [service]=2 Or [service]=3 Or [service]=6 Or [service]=7 Or [service]=8,(SELECT TOP 1 Sum(1) AS Total_Beds_Flight
FROM Tabil_Visitors
WHERE (((Tabil_Visitors.service) In (1,2,3,6,7,8)))
GROUP BY Tabil_Visitors.Num_brnamge
HAVING (((Tabil_Visitors.Num_brnamge)=[forme_Fatora]![num_brnamge]));),0) AS TT
FROM Tabil_Visitors
WHERE (((Tabil_Visitors.Num_brnamge)=[forme_Fatora]![num_brnamge]));

.

والنتيجة:

.

جعفر

[kaser906]

1 ساعه مضت, jjafferr said:

السلام عليكم

 

انا قلت "المفروض" ، وما قلت ما يصير !!

 

الاستعلام اصبح:

SELECT Tabil_Visitors.id_visitors, Tabil_Visitors.Num_brnamge, Tabil_Visitors.service, Tabil_Visitors.Travel2, Nz(DCount("[Travel2]","Tabil_Visitors","[Num_brnamge]=" & [Num_brnamge] & " and [Travel2]=" & 1),0) AS Expr1, Nz(DCount("[Travel2]","Tabil_Visitors","[Num_brnamge]=" & [Num_brnamge] & " and [Travel2]=" & 2),0) AS Expr2, IIf([Travel2]=1 Or [Travel2]=2 Or [Travel2]=3 Or [Travel2]=6 Or [Travel2]=7 Or [Travel2]=8,Nz(DCount("[Travel2]","Tabil_Visitors","[Num_brnamge]=" & [Num_brnamge] & " And [Travel2]=" & [Travel2]),0),0) AS Expr3, IIf([service]=1 Or [service]=2 Or [service]=3 Or [service]=6 Or [service]=7 Or [service]=8,(SELECT TOP 1 Sum(1) AS Total_Beds_Flight
FROM Tabil_Visitors
WHERE (((Tabil_Visitors.service) In (1,2,3,6,7,8)))
GROUP BY Tabil_Visitors.Num_brnamge
HAVING (((Tabil_Visitors.Num_brnamge)=[forme_Fatora]![num_brnamge]));),0) AS TT
FROM Tabil_Visitors
WHERE (((Tabil_Visitors.Num_brnamge)=[forme_Fatora]![num_brnamge]));

.

والنتيجة:

.

جعفر

ماشاء الله عليك أستاذ جعفر  هذا هو المطلوب : 

الله يرحم والديك ويجزيك خير في هذه الليلة المباركة

اعادها الله علينا وعليك أعواما عديدة وأزمنة مديدة ونحن وأياك في أتم الصحة والعافية

[jjafferr]

حياك الله