Unbound textBox using ComboBox as part of Dsum Criteria...

[MackMan]

Slight quandary...

I'm using a very simple unbound textbox on a very simple form, with the following Expression to find me data in a query and sum the last 30 days, based on a combo-box on my form...

Only thing is, it's showing me only the data from the last 30 days...regardless of the value in the combo.

=DSum("Credit","qryIncVsExp","TransDate>=#" & Date()-30 & "#" And "AccountID_FK="""&[cboaccount].[column](1)&"")

I'm sure it's something to do with the number of "'s I have, but I'm probably more than likely ever so wrong.

I'm in awe and totally appreciative of all your help

 

[pbaldy]

Try

=DSum("Credit","qryIncVsExp","TransDate>=#" & Date()-30 & "# And AccountID_FK= '" & [cboaccount].[column](1) & "'")