check date

G

golan

hello; i have date field in a form that update a field in temporary table
"tmppayment".
with update query i update the payment table and delete the data from
tmppayment.
i want to check in table payment if the pay date is not valid and if the
last pay is for instance 1/08 the field in the form will update to 2/08 and
the user get a message about that .
additional the pay date required to be between two date in anther table
tblcontract
i want to chack it whan i enter the data .
only in this cases the field will update.

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add additional information to excel form after original data entry 0
Append Crosstab Query to Existing Table 0
Dcount -Date Criteria - Won´t find it - 0
query question 1
chack input data 0
Sorting Multiple Tables 1
Consolidation Table from Different Excel Tabs with Different Format 1
Expiration Date Automatic Update 1

Top