Results 1 to 2 of 2
  1. 06-18-2009, 09:38 AM #1
    techexpressinc's Avatar
    techexpressinc
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    not a db field - new field expression how to?

    My query has sums i need to subtract from a fixed number and have of the report.



    New field (name=balance) = fixed number (12) minus column b and column c.

    I am having trouble getting the expression to work, I get prompted for the balance.

    Any help is appreciated. Attached is a screen print.

    Russ @ ScanInc.org
    Reply With Quote Reply With Quote
  2. 06-19-2009, 10:17 PM #2
    thhui
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    The expression should be rewritten as:-

    Code:
    Balance: 12 - [column b] - [column c]
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Compare a Field to a Field in a Prior Record with Large Datasets
    By aaron_a in forum Access
    Replies: 1
    Last Post: 02-26-2009, 11:31 AM
  2. Search All Field
    By robbiebrown34 in forum Access
    Replies: 0
    Last Post: 05-17-2007, 09:40 AM
  3. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 PM
  4. MEMO field
    By casporov in forum Access
    Replies: 1
    Last Post: 11-11-2006, 08:17 PM
  5. Field gets data from Expression?
    By Willot in forum Access
    Replies: 3
    Last Post: 12-10-2005, 06:28 PM

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

Other Forums: Microsoft Office Forums