Ha ha. Where's the fun in that? :)

Great video what would it take to add logic so that what ever the next appointment is you can click a check box to avoid weekend days?

Ooh good idea. We've got a Gold Member Bonus video coming up...

I was thinking what if it's not recurring?  Just a one off.

Another good question.

This will be nice looking to see this one.

I covered it in the Extended Cut for today's TechHelp video NetWorkDays, but here's the two lines of code you need to avoid weekends:

    ' check for sat sun
    If Weekday(NextAppointment) = 1 Then NextAppointment = NextAppointment + 1
    If Weekday(NextAppointment) = 7 Then NextAppointment = NextAppointment + 2

Easy peasy.

Yes this will work for my current project.  

V/r
Juan

Just saw it in todays video thank you Richard you always come thru.

Probably a silly question, will the last appointment date populate automatically once the next appointment date has passed? Or does that date have to be manually populated each time. I have a 90 day planner for my sales cycle and I am trying to set it up where it just keeps creating the new plan automatically.  Thanks for your assistance. Brent

From this video, I added two other date fields, nextappointment2 and nextappointment3 because I use a 90 day planner for my sales call cycle. I want to search those three fields for a range of dates, 4-1-22 to 4-30-22, and pull back only those records from the specified range. Some dates could be in multiple fields, for example 4-6-22 could be in the nextappointment or the nextappointment2 field for a different customer. Then I would like to run a report with the information which match but group by the specific dates sorted by customer. I can get the dates but the reporting is a mess. I am not sure how to set up the grouping with three fields with possible dates. Any thoughts?

First Question:  
Add Records for Followup Dates Automatically

Second Question:
Go back and watch the Expert 1 and Expert 2 courses again.

This is exactly why you DON'T put your data in in "repeating fields"  (Date1, Date2, etc)  You create a lot more work for yourself in searches and other things.
Then use your queries to pick out the data you need.

Also:  Access Appointment Database for Scheduling

Access Expert 12 covers Sorting an Grouping for reports to output the data like you described.

BTW - That little search box at the top right is a very powerful little tool.

Thanks Scott!  I press on but now with some clarity!!! I agree on the horrible set up and I knew it right after I did it. I will change it now but was just wanting to see if there may be a work around before I changed it.  I tried to look up solutions with the search box but wasn't finding what I thought I needed.  Thanks for pointing me in the right direction sir!!!! It amazes me how simple but complex this stuff can be and how very satisfying it can be when something works the way you envisioned.  With your help, along with others in this forum,  I continue to learn!!! Thank you!!

Brent you're welcome.  I'm glad that was helpful.

Sometimes the materials in the courses don't actually click for you until you can apply it to a situation you are in.
One of the most difficult things to learn is, "How do I apply xxx teaching to this thing I'm doing now.

You are so spot on!  I have watched all of the videos you mentioned before but it didn't always resonate at the time.  I watched the first video you suggested again and it is exactly what I needed. I am going to watch the other videos later, family stuff today, and get this thing working until the next hurdle!  But I can't learn without the hurdles!!! Thanks again Scott and have a great day.

The problem with the search box is that you have to know what you're searching FOR. You can find answers to most things even with a Google search (granted, most answers aren't as good as mine. LOL. JK) but you have to know what you're looking for. If you don't know that "one combo box that filters its results based on a previous selection" is called a "cascading combo box" then you might not find the answer. :)

I agree Richard!  The money is in the knowing. You mentioned an example of Ford and another car maker with that goes along these lines  I know I messed that up but I think you know what I am referring to.  And your answers are much clearer than Googles and even Microsoft!!!!!