Hi All,
i have query that calulates the month spend in one column [Month_total] then i Group it via the month using a field called [Month_] then use a sum on form to call the values
like
which shows the total spend for march does what i want but i would like to use a textbox to control the year but ive been unsuccessful
i added
to my query
here is what i tried but getting a error
any help much appreciated thank in advance
Shane
i have query that calulates the month spend in one column [Month_total] then i Group it via the month using a field called [Month_] then use a sum on form to call the values
like
Code:
=DSum("[Month_Total]","[Monthly_Cost_parts_QRY]","[Month_] = '3'")
i added
Code:
Yeardate: DatePart("yyyy",[Order_Date])
here is what i tried but getting a error
Code:
=DSum("[Month_Total]","Monthly_Cost_parts_QRY","[Month_] = '3'" & "'[Year_date]='[YearFormTXT]'")
any help much appreciated thank in advance
Shane