query problem

  • Thread starter Thread starter Fernando Ríos
  • Start date Start date
F

Fernando Ríos

Hi



I have two tables with different number of records and the fields are
numerical.

There is a difference between them.

The table 1 has a record of more than the table 2.

I am trying to realize a make-table query. The new table contains all the
records if the table 1.

I have the following problem.



In the new table, there are numerical fields of more and it do not have
value (it is null) and I cannot do arithmetical operations with those
fields.



SELECT Tabla1.ClaveMP, Tabla2.ExistMP2
FROM Tabla1 LEFT JOIN Tabla2 ON Tabla1.ClaveMP = Tabla2.ClaveMP;


Can you help me.



Fernando Ríos
 
In the new table, there are numerical fields of more and it do not have
value (it is null) and I cannot do arithmetical operations with those
fields.
Click to expand...

It's not clear just what kind of calculations you want to do! But you
can use the NZ() function to treat NULL values as zero:

[Table1].[ThisField] + NZ([Table2].[ThatField])


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top