probs w/query

[Guest]

I am using this query to find the totals for all children where child_ID is equal to the sesison variable.
there is nothing wrong with the session variable b/c other stuff that depends on it works fine.
Is there anything wrong with this query?
thanks!
SELECT Sum(tuition) FROM child WHERE child_ID = '" + Replace(total_due__MMColParam, "'", "''") + "'"

 

[Duane Hookom]

There might or might not be anything wrong with the query. Are you not
getting the correct results? Are you getting an error message?

--
Duane Hookom
MS Access MVP

I am using this query to find the totals for all children where child_ID

is equal to the sesison variable.

there is nothing wrong with the session variable b/c other stuff that depends on it works fine.
Is there anything wrong with this query?
thanks!
SELECT Sum(tuition) FROM child WHERE child_ID = '" +

Replace(total_due__MMColParam, "'", "''") + "'"