Printable View
I have created a calculated field in my query and it is working fine.But when i tried to use the same query in a report,it passes the same calculated field as a input parameter value ,Example, in a query design grid ;Total:([Price]*[Quantity]) when ran ,this will display Total records correctly.But when I ran the same query from a report point of view it asks me to enter parameter value for the Total field.Please help
Save the query then on the report design,
- click in the outer grey,
- set the data source to the saved query
Should let you put in fields on the report to the total...
Thanks for the piece of advice........ but I have checked the report properties on greyish part of thre report (as per your suggestion) design its already set to the correct record source(ie relevant query ).....though am still having the same problem .....any more help???