C
Confused87
I have three columns I want to add in my query. I want a total per row of
these three:
Funds Received 1 || Funds Received 2 || Funds Received 3 || Total Raised
Here is what it looks like in the field heading:
Total Raised: Sum([Funds Recieved 1]+[Funds Recieved 2]+[Funds Recieved 3])
(Yes, I know it is spelt wrong, but it would now take too long to change!)
The error box I get when I try to go to Datasheet View is this:
“You tried to execute a query that does not include the specified expression
‘Runner’ as part of an aggregate function.â€
‘Runner’ is one of my other fields, yet it is a field for the runner’s name(
for marathons by the way). I put it in a second time and the following
message appeared:
“You tried to execute a query that does not include the specified
expression ‘Expr1000’ as part of an aggregate function.â€
Now I’m completely muddled. Does anyone know what is going on!?
these three:
Funds Received 1 || Funds Received 2 || Funds Received 3 || Total Raised
Here is what it looks like in the field heading:
Total Raised: Sum([Funds Recieved 1]+[Funds Recieved 2]+[Funds Recieved 3])
(Yes, I know it is spelt wrong, but it would now take too long to change!)
The error box I get when I try to go to Datasheet View is this:
“You tried to execute a query that does not include the specified expression
‘Runner’ as part of an aggregate function.â€
‘Runner’ is one of my other fields, yet it is a field for the runner’s name(
for marathons by the way). I put it in a second time and the following
message appeared:
“You tried to execute a query that does not include the specified
expression ‘Expr1000’ as part of an aggregate function.â€
Now I’m completely muddled. Does anyone know what is going on!?