I have a Table called "NCR", In that table, in that table I have a material weight that is entered "MaterialWeight".
Totaled at the bottom of the report in the footer by:
Total Weight for the week: =Sum([MaterialWeight])
This gives me the total weight that is Nonconfoming for the week.
Out of that total I have different types of
Nonconforming material input in a field called the "Disposition". In that "Disposition" column we enter one of the
SCRAP, RECLASS, USE AS IS or RETURN
I want this formula to total the "MaterialWeight" if my
input for "Disposition" = SCRAP
Whit this i get the
output of #error
This doesnt work either
With this i get no output what so ever
With this i get 17,654 which is the total in Table NCR,
This works. Now I have to get it to just pull the MaterialWeight from the QUERY "NCR Weekly Query" not the entire report
=DSum("[MaterialWeight]","NCR Weekly Query","[Disposition]='SCRAP'")
With this i get #error, I need this
formula to take into consideration the date range and the data pulled by the query.
Thanks in advance
have a screen shot of the program with pbasic info to further understand what I am talking about.