Why won't this DSUM work?

[Gator]

=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")

why am I getting "syntax error in date in query expression"?

thanks

 

[Dale Fye]

Try:

with the assumption that [Text21] is the name of a control, not a field, I
would try:

=DSUM("Amount", "Deposits", "[DateDep] = #" & me.text21 & "#")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Gator]

I get the error...
the object doesn't contain the automation object 'me'

Try:

with the assumption that [Text21] is the name of a control, not a field, I
would try:

=DSUM("Amount", "Deposits", "[DateDep] = #" & me.text21 & "#")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")

why am I getting "syntax error in date in query expression"?

thanks

 

[Gator]

I got it....
=DSum("Amount","Deposits","[DateDep] = #" & [text21] & "#")

thanks

I get the error...
the object doesn't contain the automation object 'me'

Try:

with the assumption that [Text21] is the name of a control, not a field, I
would try:

=DSUM("Amount", "Deposits", "[DateDep] = #" & me.text21 & "#")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")

why am I getting "syntax error in date in query expression"?

thanks

 

[Dale Fye]

so, is "text21" actually a field name?

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

I got it....
=DSum("Amount","Deposits","[DateDep] = #" & [text21] & "#")

thanks

I get the error...
the object doesn't contain the automation object 'me'

Try:

with the assumption that [Text21] is the name of a control, not a field, I
would try:

=DSUM("Amount", "Deposits", "[DateDep] = #" & me.text21 & "#")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")

why am I getting "syntax error in date in query expression"?

thanks

 

[Gator]

at this point...it is....

so, is "text21" actually a field name?

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

I got it....
=DSum("Amount","Deposits","[DateDep] = #" & [text21] & "#")

thanks

I get the error...
the object doesn't contain the automation object 'me'

:

Try:

with the assumption that [Text21] is the name of a control, not a field, I
would try:

=DSUM("Amount", "Deposits", "[DateDep] = #" & me.text21 & "#")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



:

=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")

why am I getting "syntax error in date in query expression"?

thanks

 

[fredg]

I get the error...
the object doesn't contain the automation object 'me'

Try:

with the assumption that [Text21] is the name of a control, not a field, I
would try:

=DSUM("Amount", "Deposits", "[DateDep] = #" & me.text21 & "#")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")

why am I getting "syntax error in date in query expression"?

thanks

You cannot use the "Me" keyword within the control source of an Access
control or in a query.
"Me" can only be used in VBA.

Your original post states that the DSUM was used in a query (not
directly as the control source of a control).
You do NOT use the = sign in a query expression.
ColumnNameSum(etc....)

Also, you would need to fully qualify the [Text21] control's address.

ColumnNameSum("[Amount]","Deposits","[DateDep] = #" &
forms!FormName![Text21] & "#")

So, assuming [DateDep] is a Date Datatype and [Text21] contains a
valid date, the above should work.

 

[Mike Painter]

=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")

why am I getting "syntax error in date in query expression"?

thanks

If this is in a query leave the equal sign off
This will result in exp1Sum("[Amount]","Deposits","[DateDep] =#" &
[Text21] & "#")
and you can rename exp1 to something meaningful