problems using a parameter query

[johnoc]

i need a bit of help as i am at a loss at trying to sort out this problem<br>i am using a query to form a report the query asks for the begin, end date and the shift it all works fine but there are too calualted fields in the query &quot;total Prod&quot; and &quot;total Scrap&quot; which are caluated form the &quot;weekly&quot; table but the problem is that the to calculated total are totaling the entire colum instead of the ones i want selected by the date and shift<br>i tried to set the parameter in the criteria but i am not allowed i keep getting an error message

 

[DreewToo]

Dev Ashish's site has some good info on parameters and dates...<br><br><A HREF="

http://www.mvps.org/access/queries/qry0009.htm"

TARGET="_new">

http://www.mvps.org/access/queries/qry0009.htm</A><br><br>Using

that info, summarizing the [total Prod] and [total Scrap] between the 2 dates should be possible.<br><br>Drew<br><br>

 

[johnoc]

i had a look at the site but it was a bit to general. it wasn't what i was looking for, but the site is fairly handy though. thanks

 

[DreewToo]

Hiya Johnoc,<br><br>That site has been of great help to me.<br><br>Could you post the SQL you are using?&nbsp;&nbsp;<br><br>Drew