SQL and Access

[peekay]

I need to compile a recordset which selects all the records in a table which has two fields with a certain value for instance :<br>In the table named OrderedItems I have columns for Category,Project and Cost. I now need to sum the cost for a certain project and a certain category. The Sql I wish to use is something like the following :&nbsp;&nbsp;&nbsp;&nbsp;<br>&quot;Select * from OrderedItems where Project=&quot; & MyProject & &quot;and Category = &quot; & ThisCategory (where MyProject and ThisCategory are variables).<br>Can someone please set me on the right track to execute such a sql. <p>PK Odendaal<br><a href=mailto: pko@mweb.co.za> pko@mweb.co.za</a><br><a href= > </a><br>

 

[Ymesei]

Try this.<br><br>SELECT Sum(Cost) AS Total<br>FROM OrderedItems<br>WHERE Project=MyProject AND Category=ThisCategory;<br>