Search results

UPDATE Assessments SET Assessments.[Planned pack send date] = [Enter the planned pack send date], Assessments.[Recall 1 Expected date and time] = [Enter the planned Recall 1 date], Assessments.[Recall 2 Expected date and time] = [Enter the planned Recall 2 date] WHERE...

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...

OK thanks. I've created the 4 separate queries and they are all working. Before I try to learn how to do the union query can I just check something? If someone is missing all four pieces of information and hence appear in all for query outputs will they then appear 4 times in the union query...

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...

Thanks Mark. It's probably my controlling nature but sometimes the letters are printed but not sent on the same day so I like the date sent field to be updated when they are actually sent. Can I still use an update query in this case? For both the queries I currently use the user chooses...

Thank you for responding. Yes it's a standard letter. I'm fine with the exporting part, it's just the updating the dates that I'd like to speed up.

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...

Thank you. The height of the detail section was set long enough but as you suggested I shrunk the footer and that seemed to solve it. Seems a bit random but hooray. Thanks again, Pippa

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...

No Table 2 was empty to start with. I've changed the design now as advised on here.

It seems to have started working. Hooray, thank you. Now just to be cheeky, I'd really like it to be set so that people had to enter a date in short date form and that there was an input mask to make them do this. I made the format short date and added the relevant input mask in the property...

Do I have to use code for this or can I add CDate into the criteria statement I copied above? I've tried a few places and it doesn't seem any better. Now I think I've understood the theory of why it's not working (thank you) it would seem to make sense to me if it was <=CDATE([Enter the last due...

Sorry. So the data in the table gets uploaded from excel but then when people use the query they enter the date that they are interested in. It's that data entry that I need to "wrap"?

The data gets uploaded from an excel file rather than a user inputting it.

Thank you. So even though I have that field set as a date/time data type in the table and it is understanding it is a date enough to add 2 years to it I have to do something to it for the parameter query to work?

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 everyone, just an update, I started again. Have some new problems but I'll start a new thread for them. Thank you for the advice.

Thanks everyone, I will muddle along for a bit and see if I can make it work. I may be back with more questions. I really appreciate the help.

Plog, I don't want to push my luck but you have been so helpful I thought I should just ask about the randomisation date table. This has information on the date that participants were randomised so the study number and the randomisation date. It is in a separate excel sheet that I need to...

OK that makes total sense, thank you.