Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Chazcoral is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    9

    Multiply results


    I would like to run a query or form to produce a report that mutiplies results from two fields. I have attached a screen shot of my query.

  2. #17
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Well, you have the multiplication in the criteria, which is going to restrict that field. It sounds like you want it in the Field row. The alternative would be to have it in the report:

    =Field1 * Field2
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Current month in a field as default
    By leandrosarno in forum Access
    Replies: 6
    Last Post: 02-09-2010, 05:40 AM
  2. Can't get new field to show in my data entry form
    By Suzie in forum Database Design
    Replies: 19
    Last Post: 12-21-2009, 03:48 PM
  3. Replies: 7
    Last Post: 05-29-2009, 04:27 PM
  4. Find out changed data
    By Papote in forum Programming
    Replies: 1
    Last Post: 04-27-2009, 08:19 PM
  5. Replies: 4
    Last Post: 04-01-2009, 11:48 AM

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