Good Afternoon Ladies and Gentlemen of this forum, I had a question for all of you.

I am trying to write a query. The idea of the query is showing when a person needs a new appointment. I now have a query which gives the Last Name, the first date they visited, and a so called 'visit number'.

The visits follow a set pattern. The second appointment is always 10 days after the first one. Then, the third appointment is 2...

Wooooooooo! :D I did it! :D I finally got it to work! :D I did have to change one thing, I had to replace the comma's by these things ; , but other than that, it worked like a charm! Thanks so much for everything!

Woow, I'm just going to take the rest of the day off now, I'm excited that this worked :P Have a good day too!

I've been away for a week, but indeed, there is something fundamentally wrong with the SQL. Since I'm so new to Access, I had no idea what Dlookup() actually was, but now that I've looked a little bit into it, I saw that was indeed the solution I was looking for. I'm sorry I wasted so much of your time trying to find a solution to my problem in other ways, which were obviously not the right ones.

Now that I'm working on a little DLookup,...

Hmm, I started on your hint with the query, but it turned out that they were already all inner joins. However, then I tried a left join, and that seems to give the result I need! :D

The only problem now is that when I try to execute the Query, I get the error (Freely translated): The Query is too complex.

The SQL code is as follows:
...

Alright, I worked on trying to strip my database of unnecessary data, plus translating it (It is written in my native language, Dutch), but I can't seem to get it to work. The database is huge, and rather complicated, and I can't really show you properly what I mean without sizing it down.

I know it's kind of stupid, but, to try to make it clear regardless, I am submitting pictures anyway.
[IMGNOTHUMB]http://i1209.photobuck et.com/albums/cc384/Irianthul/Database/Psyche_Hoofdfor mulier.gif[/IMGNOTHUMB]...

Certainly, I will try to be more clear.

The database is about patients. All the other information is connected to the patient ID. I now have a form, which I call the main form. It is the form you get when you start up the database. On the first few lines of said form, it shows the general patient data, Patient_ID, Firstname, Lastname, Date_Of_Birth and Sex. Underneath that is a field, with several buttons. The buttons lead to other forms...

Good afternoon ladies and gentlemen, I had a question.

I am writing a database for an hospital, and right now I am working on one of the forms. On this form (called main form after this), there are several buttons, leading to other forms (called subforms after this), and the client wants to have a check box next to the button, which is checked off when the form has been filled in (a form counts as filled in if the date has any value...