User Profile

Collapse

Profile Sidebar

Collapse
mbardwel
mbardwel
Last Activity: Mar 20 '08, 01:49 PM
Joined: Mar 19 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mbardwel
    replied to query expression in an expression
    in Access
    That is what I thought... if anyone has any other ideas that would be great....
    See more | Go to post

      Leave a comment:

    • mbardwel
      started a topic query expression in an expression
      in Access

      query expression in an expression

      I am building a query in Access 2003. Here is my problem.

      I create an expression called SUN_ST
      In a later expression I reference a calculation based on SUN_ST
      ie, MON_ST=sum-SUN_ST

      SUN_ST is not a value in a table it is a calculation/expression within the query.

      How do I reference a query expression within an expression.

      I tried MON_ST: [sum]-[SUM_ST] and when I run the query...
      See more | Go to post
      No activity results to display
      Show More
      Working...