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

Not equal to a number

P: n/a
I am working in a query specifically the IIF statement below. Where the
five CCCCC are I want it to be number. So if the login is not equal to five
numbers then flag as new else null. Can you help.
New Employee: IIf([Login]<>"CCCCC","New","")

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Might wanna check up on regular expressions and see if the IIF supports
them.

Nov 13 '05 #2

P: n/a
With the VB code editor open I wen to help, answer wizard tab, and
typed:
Pattern

Which came up with some wild card characters that can be used for
string comparisons.

Nov 13 '05 #3

P: n/a
Based on the help text I think all you need to do is replace the C's
with the symbol #

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.