Hello, everyone:
Small problem in my DATEADD expression in Access 2003 (11.x):
I have set up the expression:
=DateAdd("d",+21,[DateServed])
Where DateServed is the date to which 21 days is to be added to
obtain the value for DateDue.
When typing the dates into the form the expression works perfecty.
I have another expression DateDiff:
=DateDiff("d",[DateDue],[DateReceived])
which works in the form and returns the difference between the date
due (DateDue) and the date received (DateReceived). It to works fine
in the form.
My problem is that the calculated data does not appear in the table
in the respective DateDue and DateReceived columns and the Differnce
columns, respectively.
Note:
When I insert the expression "=DateDiff("d",[DateDue],
[DateReceived])" In Properties Data--Control source ..., the
expression appears in the Control Source field. When I click the
down arrow to select the field into which the data is to be stored
it shows the field name replaces both the expression in the Control
Source field AND in the Expression Builder (...) window!
If I select the field, the field appears in the expression builder
window but when I insert the ezpression in the expression builder
window, the espression replaces the field name in the Control Source
field.
In other words, if in Properties--Data--Control Source -- I select
in Control Source (down arrow) the field into which the data is to
be inserted, I lose the expression (the fieldname then appears in
the expression builder as well); if I don't select the field but
insert the expression into the box or use the expression builder, I
lose the field name into which the data is to be inserted and the
data is not inserted into the table but it works in the FORM!
Any ideas why the data is not getting to the Table?
Thanks,
Harold
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
