I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a
value of 30. I then take the difference between the ship date from the
invoice and the paid date to calculate if they are paying within terms.
Everything works well, but now there's a customer with terms of 6/1. How can
I calculate if they are paying within terms when the number of days due
changes everyday?

Thanks



Jim

What does "6/1" mean with respect to terms? I have no idea how to interpret
what that means with respect to your post. Help us understand how it's to be
interpreted.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Jim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
>typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a
>value of 30. I then take the difference between the ship date from the
>invoice and the paid date to calculate if they are paying within terms.
>Everything works well, but now there's a customer with terms of 6/1. How
>can I calculate if they are paying within terms when the number of days due
>changes everyday?
>
> Thanks
>
>
>
> Jim
>
>

Hello,
Sorry, 6/1 means terms of June 1.

Jim

"Ken Snell" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What does "6/1" mean with respect to terms? I have no idea how to
> interpret what that means with respect to your post. Help us understand
> how it's to be interpreted.
>
> --
>
> Ken Snell
> http://www.accessmvp.com/KDSnell/
>
>
> "Jim" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
>>typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a
>>value of 30. I then take the difference between the ship date from the
>>invoice and the paid date to calculate if they are paying within terms.
>>Everything works well, but now there's a customer with terms of 6/1. How
>>can I calculate if they are paying within terms when the number of days
>>due changes everyday?
>>
>> Thanks
>>
>>
>>
>> Jim
>>
>>
>
>

So, how would you calculate the number of days due? Is it a countdown from
the shipping date to the next June 1 date? Or something else? Show us some
examples using data.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Jim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
> Sorry, 6/1 means terms of June 1.
>
> Jim
>
> "Ken Snell" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> What does "6/1" mean with respect to terms? I have no idea how to
>> interpret what that means with respect to your post. Help us understand
>> how it's to be interpreted.
>>
>> --
>>
>> Ken Snell
>> http://www.accessmvp.com/KDSnell/
>>
>>
>> "Jim" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
>>>typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having
>>>a value of 30. I then take the difference between the ship date from the
>>>invoice and the paid date to calculate if they are paying within terms.
>>>Everything works well, but now there's a customer with terms of 6/1. How
>>>can I calculate if they are paying within terms when the number of days
>>>due changes everyday?
>>>
>>> Thanks
>>>
>>>
>>>
>>> Jim
>>>
>>>
>>
>>
>
>