blank entries in a query

[dek394]

I have a simple query which runs two tables against one master table. When the query is done running, there are some blanks spaces in the resulting table. Is there any way to get these blank spaces to equal "0"? Thanks in advance for the help.

 

[GingerR]

in the query, instead of the field that might be blank, you can put

=iif([Field] is null,0,[Field])

 

[dek394]

That looks like it will work, but I'm not too good at SQL, so I don't know where to put something like that. Here is my SQL code for one of the queries:

SELECT [Partgroup List].Prod_ID, [March 2003 Capital Cabs].EXTENDED_COST, [April 2003 Capital Cabs].EXTENDED_COST
FROM ([Partgroup List] LEFT JOIN [March 2003 Capital Cabs] ON [Partgroup List].Prod_ID = [March 2003 Capital Cabs].Prod_ID) LEFT JOIN [April 2003 Capital Cabs] ON [Partgroup List].Prod_ID = [April 2003 Capital Cabs].Prod_ID;

Can you tell me where to put that if statement?
Thanks
Dennis

 

[dek394]

Nevermind I figured out where to put it, thanks a lot for the help Ginger.

Dennis