- Joined
- Oct 19, 2012
- Messages
- 1
- Reaction score
- 0
I am have been hunting for help all day online, been down about 10 deadends and now I am just plain frustrated and I am at a loss. So, any help that I can get right now would be appreciated.
This is the problem: I am trying to run a update query adding the subtotals of 4 fields, all in the same table, to a 5th field, also in the same table, using the BusinessDate. "Nothing to fancy ... " I am learning this is not the case ....
example:
Table1
09/01/2011
field1 20
field2 10
field3 5
field4 0
total = 35
I need that "35" to update into a field that I have set up already in the same table.
Here is my query:
=DSum("Nz[field1],0) + Nz([field2],0) + Nz([field3],0) + Nz([field4])","Table1","[BusinessDate] = Date()")
When I paste this into the "update to" field in the query I get a "Unknown" error.
What in the blazes am I doing wrong?????
This is the problem: I am trying to run a update query adding the subtotals of 4 fields, all in the same table, to a 5th field, also in the same table, using the BusinessDate. "Nothing to fancy ... " I am learning this is not the case ....
example:
Table1
09/01/2011
field1 20
field2 10
field3 5
field4 0
total = 35
I need that "35" to update into a field that I have set up already in the same table.
Here is my query:
=DSum("Nz[field1],0) + Nz([field2],0) + Nz([field3],0) + Nz([field4])","Table1","[BusinessDate] = Date()")
When I paste this into the "update to" field in the query I get a "Unknown" error.
What in the blazes am I doing wrong?????