Results 1 to 3 of 3

Thread: MS Access Queries vs Reports

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2005
    Posts
    95

    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

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    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...

    BOFH Now, BOFH Past, Information on duplicates

    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...

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Aug 2005
    Posts
    95

    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
  •  



Click Here to Expand Forum to Full Width