There are lots of decades of Access experience represented in this group so feel free to ask away.
It's always good to provide enough significant information. The problem with new Access developers is they don't always know what is "significant". Most of the time it helps if you provide table and field names, relationships, and data types.
Duane Hookom MVP
MS Access
----------------------------------------
> From: zjubias@gmail.com
>
> It did work Duane, huh, it seems my first mail did not come to you..
>
> It works, thanks a lot..
>
> Definitely, I will be needing lots of assistance from the pros like you Sir.
>
> Currently, am working with the db which I inherited, and since am not an
> code savvy, I will be a regular student here..
>
> zjubias
>
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
>
> zjubias,
>
> Did my suggested expression work or are you still looking for assistance?
>
> Duane
>
> ----------------------------------------
>> From: zjubias@gmail.com <mailto:zjubias%40gmail.com>
>>
>> Duane,
>>
>> Sorry I left your last paragraph.
>>
>> With regards with business rule of our company, yes we are having 1 day
> plus
>> as a grace period..
>>
>> Regards,
>> zjubias
>>
>>
>> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Duane
> Hookom
>>
>> zjubias,
>>
>> I expect it is just a missing comma.
>>
>> =DateAdd("yyyy",1,[EffDate])+1
>>
>> With a question like this, you should be providing us with the business
> rule
>> like "the expiry date is one year plus one day from the EffDate".
>>
>> Duane Hookom MVP
>> MS Access
>>
>> ----------------------------------------
>>> From: zjubias@gmail.com <mailto:zjubias%40gmail.com>
> <mailto:zjubias%40gmail.com>
>>>
>>> Hello All,
>>>
>>> Could someone help me please,
>>>
>>> What is the missing part of the below expression? I want to calculate the
>>> expiry date from my EffectiveDate (EffDate). I got invalid syntax error.
>> Am
>>> placing the expression into the control source of my textbox
> "ExpiryDate".
>>>
>>> =DateAdd("yyyy",1[EffDate])+1
>>>
>>> Thank you,
>>>
>>> zjubias
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (18) |
Tidak ada komentar:
Posting Komentar