Parameter value when running query

[Guest]

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

 

[Guest]

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

One solution to your problem
----------------------------------
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..
----------------
Another solution would be to leave the final Total until you create your report - but that depends upon whether you were planning to go that far with you information

Regard
Tezba

----- Ryan wrote: ----

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