Recent content by malcster2

thanks, but i got this message back - 'You tried to execute a query that does not include the specified expression 'Expr1' as part of an aggregate function' any ideas?

SELECT tblNewTrans.Buyer, Count(tblNewTrans.Buyer) AS ["Total New Leads"], (select count(tblnewtrans.buyer) from tblnewtrans where tblnewtrans.new=true) AS Expr1, (select count(tblnewtrans.buyer) from tblnewtrans where tblnewtrans.refund=true) AS Expr2 FROM tblNewTrans GROUP BY...

i have created a report on a selected querie that runs of a main table. fields include dates i need to run the report based between a start and finish (in other words,between these dates) date, which are selected on a main menu screen. so in other words, i'm changing the querie everytime, how...