Recent content by TYLER_DURDEN

GREAT THANKS!!!

Ok, I have three dates. I want it so that after I put a date in the first date box (No Show Date) the second date box (kept Date) turns yellow until it is filled in with a date at a later time. As soon as a date is entered into the second date bow, I want it to automatically return to the...

Whoa!!! You rock!!! Thank you so much!!!

Oops, here it is Here it is.

Ok, you all have helped me so much in the past, and I thank you for it. I've got a new one. I have three dates in a querie. When you enter the first date (No Show Date), it automatically puts the third date (Due Date) at 30 days from then. The second date (Kept Date) is the date that hopefully...

I hope my comment above didn't upset anyone. After posting this I realized I had forgotten the database link. :) :D :p

Son of a....here you go.

Holy crap, I finally realized what you mean't by hot!!! It was a typo. Here it is again without the typo. Ok, you all have helped me so much in the past, and I thank you for it. I've got a new one. I have three dates in a querie. When you enter the first date (No Show Date), it...

Woo Hoo!!! I think I got it!!! THanks alot!!! Now I need to figure out how to get the database to automatically send me an email when ever one of these patients hits my query for an appointment in 5 days. Any help? I know I posted this question earlier, but I found the answer confusing. TD

Here, maybe this will work.

I tried to attach my database, but it said it was an invalid format. But here is a pic of the query.

Whoa Normalise??? Yes that is bascially how mine is setup. What actions must I take to Normalise it??? Thanks.

I copied and pasted it into my criteria, but i get nothing, what am I doing wrong. Did I need to make a different query from the one I already have???

What I need is to build a query, that when I open it shows me only the patients that will have an appointment 5 days from now. I already have a query built that when I put in the first appointment date it automatically sets up the dates for the next 8 appointments, but what I need is for it to...

I need my database to send me an email notifying me of certain individuals five days before a scheduled appointment. Basically, I want to receive an email stating the names of individuals that will have an appointment 5 days from now. I currently have a query setup with that will automatically...