Moving from Access to SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am haveing a problem with this.
it is on a form
Sum(nz([UnitsReceived])-nz([UnitsSold]))

i can not figure out what i need to change it to to work with SQL.
Thanks in advance

Sum(IsNull([UnitsReceived], 0) - IsNull([UnitsSold], 0)) <<<<<<< this
fixed the query
 
Jon said:
I am haveing a problem with this.
it is on a form
Sum(nz([UnitsReceived])-nz([UnitsSold]))

i can not figure out what i need to change it to to work with SQL.
Thanks in advance

Sum(IsNull([UnitsReceived], 0) - IsNull([UnitsSold], 0)) <<<<<<<
this fixed the query
Click to expand...

On a form you shouldn't have to change it. Where are you using it and how is it
not working? On a continuous form it would need to be in the header or footer.
In a single view form it will only sum the one record you are looking at.
 
Rick Brandt said:
Jon said:
I am haveing a problem with this.
it is on a form
Sum(nz([UnitsReceived])-nz([UnitsSold]))

i can not figure out what i need to change it to to work with SQL.
Thanks in advance

Sum(IsNull([UnitsReceived], 0) - IsNull([UnitsSold], 0)) <<<<<<<
this fixed the query
Click to expand...

On a form you shouldn't have to change it. Where are you using it and how is it
not working? On a continuous form it would need to be in the header or footer.
In a single view form it will only sum the one record you are looking at.
Click to expand...

It is in a datasheet view "Sum(nz([UnitsReceived])-nz([UnitsSold]))"
it works great in a mdb file but when i upsize it to SQL and it makes the
adp file it will not work
 
Jon said:
It is in a datasheet view "Sum(nz([UnitsReceived])-nz([UnitsSold]))"
it works great in a mdb file but when i upsize it to SQL and it makes
the adp file it will not work
Click to expand...

Ah, I didn't get the ADP part before. I have no idea then. I strictly use
MDBs against SQL Server.
 
Thnaks for the help that you gave me on the first part

i finely figured out the other


Thanks Again

Rick Brandt said:
Jon said:
It is in a datasheet view "Sum(nz([UnitsReceived])-nz([UnitsSold]))"
it works great in a mdb file but when i upsize it to SQL and it makes
the adp file it will not work
Click to expand...

Ah, I didn't get the ADP part before. I have no idea then. I strictly use
MDBs against SQL Server.
Click to expand...
 
Back
Top