Update Table from form or query

[jquest]

Hi Again;

I am improving my database and have to overcome some original design
mistakes. I have 3500 records in the table and I have had to insert new
fields to track things I originally didn't forsee.
The new fields in the table now show nulls where there is no data. When I
run a query based on the table and including the field that contains about
1000 records with appropriate numeric data in the field, I can't get the
query to calculate a field that contains a null value.(Around 2500 records
contain null vaqlues in 6 different fields) The amount of work required to
go in and physicaly enter a 0 value is just too much.
Is there a way to force the query to insert zeros in the table where nulls
occur and perform the calculations I need (The fields needed to perform the
calculation contain nulls presently)
TIA

[PC Datasheet]

Use the following expression in your calculation:
NZ([YourField],0)
In thise expression, Access will use the value in "YourField" if it is not
Null or use 0 if it is Null.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"jquest" <ad******@telus.net> wrote in message
news:n9SId.18912$Qb.1462@edtnps89...

Hi Again;

I am improving my database and have to overcome some original design
mistakes. I have 3500 records in the table and I have had to insert new
fields to track things I originally didn't forsee.
The new fields in the table now show nulls where there is no data. When I
run a query based on the table and including the field that contains about
1000 records with appropriate numeric data in the field, I can't get the
query to calculate a field that contains a null value.(Around 2500 records
contain null vaqlues in 6 different fields) The amount of work required to
go in and physicaly enter a 0 value is just too much.
Is there a way to force the query to insert zeros in the table where nulls
occur and perform the calculations I need (The fields needed to perform the calculation contain nulls presently)
TIA

[jquest]

Thank You. I couldn't make a chart from the table, and without calculating a
query with Nulls present, I couldn't do it with a Query either. It works
now.

Thank You

"PC Datasheet" <no****@nospam.spam> wrote in message
news:UR*****************@newsread1.news.pas.earthl ink.net...

Use the following expression in your calculation:
NZ([YourField],0)
In thise expression, Access will use the value in "YourField" if it is not
Null or use 0 if it is Null.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"jquest" <ad******@telus.net> wrote in message
news:n9SId.18912$Qb.1462@edtnps89...

Hi Again;

I am improving my database and have to overcome some original design
mistakes. I have 3500 records in the table and I have had to insert new
fields to track things I originally didn't forsee.
The new fields in the table now show nulls where there is no data. When I run a query based on the table and including the field that contains about 1000 records with appropriate numeric data in the field, I can't get the
query to calculate a field that contains a null value.(Around 2500 records contain null vaqlues in 6 different fields) The amount of work required to go in and physicaly enter a 0 value is just too much.
Is there a way to force the query to insert zeros in the table where nulls occur and perform the calculations I need (The fields needed to perform

the

calculation contain nulls presently)
TIA