|
-
Oct 31st, 2005, 04:21 AM
#1
Thread Starter
Lively Member
MS Access Queries vs Reports
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
-
Oct 31st, 2005, 05:45 AM
#2
Re: MS Access Queries vs Reports
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...
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Nov 1st, 2005, 07:00 AM
#3
Thread Starter
Lively Member
Re: MS Access Queries vs Reports
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???
Last edited by kenone; Nov 2nd, 2005 at 03:31 AM.
Reason: rephrasing
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|