(off-topic) MS Access help
Thread Starter
Member
Joined: May 2000
Posts: 2,325
Likes: 0
(off-topic) MS Access help
I am trying to make Access determine the default field value of "RenewOn" based on the value of the field "JoinedOn" If I use this VB code in the expression builder, I get an error:
= dtRenewal
dtRenewal = JoinedOn
count = 0
Do Until dtRenewal > date
dtRenewal = DateAdd("yyyy", 1, dtRenewal)
count = count + 1
If count > 20 Then Exit Do
Loop
The expression you entered contains an invalid syntax
you may have entered an operand without an operator
I have never dealt with expressions in Access before, and I am somewhat confused. Using help in access doesn't do me much good. Does anyone know how to do this? Thanks taking the time to read this, and thanks in advance to anyone who attempts to help me out.
= dtRenewal
dtRenewal = JoinedOn
count = 0
Do Until dtRenewal > date
dtRenewal = DateAdd("yyyy", 1, dtRenewal)
count = count + 1
If count > 20 Then Exit Do
Loop
The expression you entered contains an invalid syntax
you may have entered an operand without an operator
I have never dealt with expressions in Access before, and I am somewhat confused. Using help in access doesn't do me much good. Does anyone know how to do this? Thanks taking the time to read this, and thanks in advance to anyone who attempts to help me out.
Thread
Thread Starter
Forum
Replies
Last Post
Respect the Cock
TT (Mk1) Discussion
6
Aug 2, 2001 04:08 PM
harinder
S4 / RS4 (B5 Platform) Discussion
1
Sep 10, 1999 06:49 AM
Hamakua_Boy
TT (Mk1) Discussion
0
Aug 7, 1999 03:05 PM
