Search results

Hi everyone, I want to do something which sounds simple but I can't make it work (story of my life with ACCESS). In my database I have individuals participating in a research study. They each have an individual ID number. Three are 5 relevant fields to what I am trying to do: Timepoint...

Hi. I am having a problem with a query. There are various fields involved but the important ones are a send date, withdrawal, and 4 responses. I then also have a calculated field which is 3 months after the sent date. I want the query to show me everyone who has a sent date, does not have...

Hi I'm sure this should be really simple but I can't work it out. I have a database where I need to send letters to people. I run a query to search for the relevant people, export the list to excel and use a mail merge to send them the letters. I then run another query where it runs...

Hi everyone, I hope that there is a simple answer to this. I have a form which in Design View looks fine but when I switch to form view you can only see the top part of it. You can scroll to see the rest but I would like to not have the bottom part of the screen wasted when you could see some...

Hi, I have a field called Randomised Date and in a query I have created a field called 2 year follow-up date. In the Field in the query it says: 2 Year follow-up date: DateAdd(2yyyy, 2[Randomised Date]). In the Criteria for this I have written <=[Enter the last due follow-up you'd like to...

Hi I am building my first database and have come up against a problem. I am running a query across two tables and the criteria is that a field in the second table is null. What I've realised is that this doesn't seem to make sense to ACCESS if their isn't a record for that person in Table 2...