By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,104 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,104 IT Pros & Developers. It's quick & easy.

Update Table from form or query

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.