Parameter value when running query

message from =?Utf-8?B?Unlhbg==?= on 22 May 2004
Hello I created a query from one of my tables and I had five colums in my table. So in my query I calculated the sum of each column in the table. I also added in an extra field in my query that was suppose to add together the sum of each column so I could get a total of each column. when I run the query it ask for the parameter value for each column. What is going on. my expression for the last field looks like this--- Expr1: [SumOfJulia]+[SumOfAshley]+[SumOfMegan]+[SumOfTiffany]---- Thanks for any help. Sorry if this is basic but I am just starting to learn access and databases. I am actually a beginning web designer but I am much better at that. Again Thanks. Ryan
 
=?Utf-8?B?VGV6YmFy?= replied to =?Utf-8?B?Unlhbg==?= on 22 May 2004
The problem your having is that Access can't process more than one calculation step at a time. Lots of people have this problem when they're working with queries.

Create a final column that adds up each record - eg:

LineTotal: [Julia]+[Ashley]+[Megan]+[Tiffany]

Make sure your expression for that column is 'Sum'.

Alternatively...
 

Archived message: Parameter value when running query (Microsoft Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.