getting query results on a form

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,
Following querry returns 12 values.

SELECT Format([datvoor],"yyyymm") AS Expr1, Sum(Voorschr.REEKS) AS
MonthTotal
FROM Voorschr
GROUP BY Format([datvoor],"yyyymm"), Year([DATVOOR])
HAVING (((Year([DATVOOR]))=2003));

I want to get these values on a form but I don't know how.
Can somebody please explain?
Thanks
 
Hi,
Following querry returns 12 values.

SELECT Format([datvoor],"yyyymm") AS Expr1, Sum(Voorschr.REEKS) AS
MonthTotal
FROM Voorschr
GROUP BY Format([datvoor],"yyyymm"), Year([DATVOOR])
HAVING (((Year([DATVOOR]))=2003));

I want to get these values on a form but I don't know how.
Can somebody please explain?
Thanks
Click to expand...

One way would be to simply base a continuous Form on the query.

If you want them side by side rather than lined up one above the
other, you could use a Crosstab query instead of the above Totals. You
may also want to change the HAVING clause to WHERE - WHERE filters the
records before you sum them, HAVING sums all the records in the table
and then throws away all the sums except for that year.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top