How to generate a Report basing from Query?

lerwane

Registered User.
Local time
Today, 16:17
Joined
Jan 9, 2004
Messages
22
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.
 
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
 
thanks

thanks Tay! It worked!!! :)
 

Users who are viewing this thread

Back
Top Bottom