Have a form in Access 2010 that takes data from a price_list_qry, connects to client_INFO_qry and appends to history for Billing. There is an item in the price list that clients have done either 6 months or one year later and I have a field called ReminderDueDate in Both the Client_INFO_qry and Billing_History_tbl.
My client_INFO_qry takes the date the item was received and calculates 6 months or ONE year from that date called NextVacDate6Mo or NextVacDate1yr. I currently cut and paste the applicable result into the ReminderDueDate but would like that to happen automatically.
I'm sure there's a simple INSERT INTO I could write but what I can't figure out is that there's two different times 6Mo or 1yr depending on the Item and what gets really tricky is one item varies depending on age, But I'll deal with that later once I figure this one out.
The db is for a horse vet and the items are vaccines. Some vaccines are given every six months and others yearly. For instance, Rabies is yearly. Rabies Vaccine is in the price list table. Once I enter the DateOfVisit the NextVacDate calculations appear and then I cut and paste. My db is not relational.