If you added the field after 1600 records were created, then the new field
will have a NULL value for those 1600 records. That is why your SQL did not
work. If you had used :
If strLoginAmount IS NULL then
strLoginAmount = 1
etc
that would have worked
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 07, 2004 9:11 AM
Subject: [AspClassicAnyQuestionIsOk] If then else block very simple?
>
> I have a field name LoginAmount that is empty in my access DB as I added
it
> way after I have 1600 plus members. I have a code block now to test if it
is
> emplty and if it is then it will = 1. It is not working.
>
>
> 'If strLoginAmount = "" Then
> strLoginAmount = 1
>
> 'Else
> 'strLoginAmount = strLoginAmount + 1
>
> 'End If
>
>
>
> I just want it to = 1 if it is emply Else will be incemented. What is the
> proper syntax?
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
