Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2003

Tip: Looking for answers? Try searching our database.

trying to do a comparison on numeric fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Monika Schwartz - 29 Sep 2003 18:29 GMT
Hello all,

I'm trying to do an if..then...else comparison where my
condition is one field being greater than or equal to
another field. Both of the fields are numbers. What's
happening is that it seems to be doing a string comparison
of them. If one number is 200 and the other is 1000, it
thinks the 200 is greater. I could understand if my
datasource were a text file, but it's a query out of
Access and these are numeric fields.

I would really appreciate any assistance you can provide.
Thanks!!

Monika
Cindy Meister  -WordMVP- - 30 Sep 2003 13:14 GMT
Hi Monika,

See my responses to Jonathan Crow on the use of quotes when
comparing string vs. numerical data. Basically: don't use
quotes when you want to force a numerical comparison; use
quotes when you do.

> I'm trying to do an if..then...else comparison where my
> condition is one field being greater than or equal to
[quoted text clipped - 4 lines]
> datasource were a text file, but it's a query out of
> Access and these are numeric fields.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.