General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a receivables table that I want to add information too but can't figure out how to do it. Here are the rules to adding to it. I have customers who are either billed annually or monthly. They have a program code. It is marked in the program table as either monthly or annually.
I want it to work so that when the user hits a button it will add a record for the annual customers only if they aren't in the receivables table within the past year and add the monthly people in once a month. I have it set up so that the user can only do it once a month as it is. It takes a look at the last date in the receivables table and compares it to the month of the date. If there is match you can't click the button till next month. I'm just having a problem getting the annual people to work. Any ideas?
TIA,
Tyler
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only