View Full Version : How to generate a Report basing from Query?


lerwane
01-12-2004, 02:23 AM
Please help!

I have a form FORM1 that will accept the ff: fields (day1, day2) then stored it in TABLE1, then in query option
I created a query QRYDATE for some calculations on that fields. Now, the output
of that is in the QRYDATE, fields are : (dyear, dmonth).

My question now is, How can I generate a report using the QRYDATE?
Those fields were generated from the query, they are not inputted by the user
(dyear, dmonth are not present in FORM1).

Kindly give me a detail procedure on how to do this.

Thanks.

Tay
01-12-2004, 02:57 AM
Unless I'm missing something, if you have saved your query with the calculated fields in it, you should just be able to create a report, and when you choose the fields you want in your report, the calculated fields should also appear in the list, so simply select them. It doesn't matter whether you create the report manually or via the wizard. HTH

lerwane
01-12-2004, 09:54 PM
thanks Tay! It worked!!! :)