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 following:
SCRAP, RECLASS, USE AS IS or RETURN
I want this formula to total the "MaterialWeight" if my input for "Disposition" = SCRAP
=DSum("[MaterialWeight]","[Disposition]=SCRAP")
Whit this i get the output of #error
This doesnt work either
=DSum("[MaterialWeight]","NCR","[Disposition]=SCRAP")
With this i get no output what so ever
=DSum("[MaterialWeight]","NCR","[Disposition]='SCRAP'")
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
I have a screen shot of the program with pbasic info to further understand what I am talking about.
http://i13.photobucket.com/albums/a2.../DSUMQUERY.jpg