update query based on date difference

  • Thread starter jomara via AccessMonster.com
  • Start date
J

jomara via AccessMonster.com

I have a multuser database for salespeople i want to be able to remove the
contact from their list if they do not get them to buy within 60 days. I
have a date created field, and a sale date field the sales date is a
continious form i need to only take the most recent date. I also have a
yes/no box to send the contact to a lead box where i can give it to someone
else. I have the moving the lead part down just not sure how to use the date
fields to make this happen automaticly
 
J

jomara via AccessMonster.com

sorry for the double post
I have a multuser database for salespeople i want to be able to remove the
contact from their list if they do not get them to buy within 60 days. I
have a date created field, and a sale date field the sales date is a
continious form i need to only take the most recent date. I also have a
yes/no box to send the contact to a lead box where i can give it to someone
else. I have the moving the lead part down just not sure how to use the date
fields to make this happen automaticly
 

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

Top