7601105166084
asked on
Need help with Calculated Access SQL syntax for selecting data within a certain period
STATUS:IIF([The_Date]<= GetDate() AND IsNull([STATUS]),"Write",[ STATUS])
I have a vba module with function,
or if I could get it to work just by using SQL
I have a vba module with function,
or if I could get it to work just by using SQL
Function GetDate()
dim a
a = weekday(now(),vbmonday)
a = int(now())-a
a = GetDate
End Function
ASKER
Sorry you are right i re-wrote the function incorrectly [only here ((-:] but is there anything else which seems wrong.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks - i think i was using the field name too instead of an alias.
Open in new window