- **Running & Setting Up Queries**
(*http://www.officefrustration.com/forumdisplay.php?f=25*)

- - **How to calculate days due?**
(*http://www.officefrustration.com/showthread.php?t=1119552*)

How to calculate days due?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 |

How to calculate days due?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" wrote in message ... 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 |

How to calculate days due?Hello,
Sorry, 6/1 means terms of June 1. Jim "Ken Snell" wrote in message ... 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" wrote in message ... 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 |

All times are GMT +1. The time now is 09:59 AM. |

Powered by vBulletin® Version 3.6.4

Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.

OfficeFrustration.com