query problem

[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

 

[John Vinson]

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.

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