Recent content by horncastlejohn

Hi, Thanks Brian, I will have a look through what you have done. Much appreciated hopefully that will set me on the right track. I had noticed the problems with the tables opening - something else to puzzle over! Thanks again. John

Thanks Brian, i am still learning the ropes with access (as you can probably guess!) I have not yet had experience of using a form to drive a query. How does one go about doing that? Thanks, John.

Ok here is a cut down copy of the database. I am more than a little puzzled, the original problem now seems to have resolved, although I now get a different error message!

Not sure, can I post a whole database to the forum?

Hi thanks folks, In my defence I inherited the work that someone else did on the database, so the oringinal field names where created by someone else! I shall remove the spaces when I get the chance. Unfortunately the query still is not working, it now only asks for the date to serach on (as...

Hi Guus2005 thanks for the reply, I tried the two query approach as you suggested however it still isn't working running query 2 now causes it to ask for values for "pt name" regimen etc. I suspect its square brackets causing the problem however taking them out for the values held in fields...

Hi all, I am trying to create a query that will calculate the date for a follow up appointment based on a dateadd function which uses a starting date and an interval (both held in a table) and then only display certain of the results based on a parameter (another date) defined when the query is...