Can I write a DSum function in query, with two criteria?
that is, I want to collect quantities according to products from the beginning of the year to a certain date which is the date field in a form. I am trying to do a thing like this: =DSum("[qty]","salestbl","[PRODUCT H NAME] = “ field in form”[PRODUCT D NAME]") AND DATE =between “01.01.2021”, “A DATE IN FORM”.
that is, I want to collect quantities according to products from the beginning of the year to a certain date which is the date field in a form. I am trying to do a thing like this: =DSum("[qty]","salestbl","[PRODUCT H NAME] = “ field in form”[PRODUCT D NAME]") AND DATE =between “01.01.2021”, “A DATE IN FORM”.
Last edited: