MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Easy Question


Posted by Wendy on January 18, 2002 11:16 AM

In a queries results, if a field has no values to return, can I tell Access to automatically place a zero in that field? (These would be currency or numeric fields already) If so, how?


Posted by Barrie Davidson on January 18, 2002 2:19 PM

You can use an if statement in Access. Something like:

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

Note that you'll have to include a field name in the field box so you'll probably want something more like:

New Field Name: =iif([Table].[Field] is null,0,[Table].[Field])

Regards,
BarrieBarrie Davidson