hi nico
tnx for the reply... heres my query1
SELECT Efa_pur.ExpiryD ate, Sum(Efa_pur.NoM eds) AS SumOfNoMeds
FROM Efa_pur
GROUP BY Efa_pur.ExpiryD ate
and query2
SELECT DISTINCTROW Sum(Efa.Pills) AS [Sum Of Pills]
FROM Efa
GROUP BY Efa.ExpDate;
sir, can i send you attachment here? i'll give you the details of my formula created in excel file that i wanted to replicate in my queries...
Geraldpauig
Last Activity: Sep 27 '10, 08:38 AM
Joined: Sep 25 '10
Location:
-
How compute and link table 1 and table 2
Hi there,
Got prob on computing this fields... i want to sum up a purchased field then less consumed field in query2, to have total available... below are my sample data:
formula on the "available" : would be if total consumed will be higher than sep1 purchased, it will tag as "0" else output total purchased - total consumed
i have query 1 which contains:
date: purchased: & available... -
How to convert excel formula to ms access
Hi there, need help in converting the excel fomulas to ms access.
=IF(C2<=0,IF(SU M(B$2:B3)<F$2,0 ,SUM(B:B)-F$2),"")
below is the data from query1 and query2
QUERY1
COLUMN ACOLUMN B COLUMN C
DATEPurchasedAvailable
cell2 September 30, 201050 0
cell3 December 31, 2010100 172*
cell4 January 01, 201110
cell5...
No activity results to display
Leave a comment: