Thanks

P

Pat

Thank you Ken. I used an update query using the formula
and then changed the field to a number (from text) in
design view. I wish Access had a description on CDbl and
Nz like Excel provides for functions(though not on these,
doh!) so I can figure out why it works.
 
K

Ken Snell

ACCESS does have info on these functions in the Help file.

Easiest way to get this info is to type Nz in the Immediate Window, and
then, while the cursor is on the Nz, press F1 key. Same for CDbl to get info
about it in Help.

Also, I almost missed your post; best to keep your replies in the same
thread so that they can be seen more easily.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Using lookup functions for Order Sheet 1
Word 2016 - Difficulties Learning Style Creation/Application 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Cross-reference Insert Default Change 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Page numbering with Merged Document and IF statements 1
How To Rapidly Copy Formulas? 0

Top