probs w/query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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, "'", "''") + "'"
 
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
Click to expand...
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 = '" +
Click to expand...
Replace(total_due__MMColParam, "'", "''") + "'"
 
Back
Top