Results 1 to 3 of 3
  1. #1
    beanhead0321 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    14

    Calculated column in a report

    Hey Guys



    So even though it says I'm using Access 2010 (which is on my computer), I'm programming for the company which uses 2007. And in 2007, there are no calculated fields. I need a cost column in my report which will have the function

    =[Quantity]*[Price]

    Both of which are also on my report. For the cost, I created a new column and put this formula into the control source. However, every time I try to run the report, it tells me to give it parameters for Text16, which is the textbox for that column. I'm not really sure what to do at this point.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Text16 is referenced somewhere in the report, either in the RecordSource query or in another textbox, but Access is not recognizing it so handles it by treating it as an input parameter prompt. Need to find that reference and fix whatever is wrong with it. Are you sure Text16 is the name of textbox in report?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    beanhead0321 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    14
    I see what I did. That textbox was not the problem. The problem was from my total cost textbox which was
    =Sum([Text16])
    I dont think Access 2007 supports summing calculated textboxes. I switched it to
    =Sum([Quantity]*[Price])
    And it worked fine. Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 08-09-2011, 09:04 AM
  2. creating a calculated column
    By bold01 in forum Access
    Replies: 13
    Last Post: 02-10-2011, 08:17 AM
  3. How To Print Calculated Dates on Report
    By ChrisCione in forum Reports
    Replies: 2
    Last Post: 01-15-2011, 03:26 PM
  4. Calculated expression in report
    By Grizz2 in forum Reports
    Replies: 3
    Last Post: 12-20-2010, 08:50 PM
  5. Sorting a Report by a Calculated field
    By mulefeathers in forum Reports
    Replies: 1
    Last Post: 05-22-2010, 08:21 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums