Simple Expression

[Bridgid]

i am a new user of access and am having a problem getting it to solve an expression.
i have created a query that totals 3 colums of numbers between specified dates. i need to subtract two of the columns from the third for a fourth total. i have tried inserting the expression =[first column]-([second column] + [third column]) - the program tells me the expression is too complicated and can't be solved. any help would be appreciated.

[RuralGuy]

Are you using the Query Builder? What you are doing should work. BTW I moved your thread to Queries as you can see.

[Bridgid]

i originally used query builder but i am now trying to add this expression to a query that is already built - just going into design mode to make the change

[RuralGuy]

Let us know if it is still being stubborn or starts to behave.

[Bridgid]

okay, moved a few things around and finally got the expression to work!!
Now, the column header for the expression is "expression 1" how do I change that? do i just put the title i want in front of the expression?

[RuralGuy]

Exactly! YourTitle:=...

[Bridgid]

Thanks for your help.

[RuralGuy]

Glad to be of service. Is this thread ready for the "Solved" thread tool?