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

Integer in a access query

P: 157
Hello guys!

Is there any way to dim a calculated field in a query as integer or long or something?

I want to achieve that zero's come in the field if it is blank like it does in a table. This is because of further calulating on the field
Aug 26 '08 #1
Share this Question
Share on Google+
1 Reply

P: 167
You can use Nz() function for your calculated field.
Look it up in you access help!
Aug 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.