Search results

OK Wow, thank you. I need to take a minute (or a day) to process all of that but my initial question is about the consent table. That makes sense to me but I need a form that shows all the consent calls that have been made for one person, and I know you said that's not how I should plan the...

OK I know this sounds stupid but it was actually clearer in a picture from my phone than with a screenshot so I've attached that. There are more fields in Table 2 but I'm not sure they are important at this point.

Thank you for trying to guide me. There will never be a situation where there isn't data in the second table. Every single person in the first table needs to have data in the second table as well. I made it like this because of trying to keep it simple when uploading the data that comes from...

Sorry about the table name but if I change it now I'll have to go and change all the queries etc won't I? Basically yes the first field is ID which is an autonumber and the second is Study Number 2 which is a 6 digit number that I want to be the same as Study number (the Primary Key in the...

The autonumber field is the primary key for the second table not the foreign key (study number 2) that I am trying to add these numbers into. Is that still a problem?

I'm so sorry but I'm driving myself mad with this.It just says "Syntax Error in INSERT INTO statement". I can't copy and past because my database is in a separate secure area but the below is exactly what I've written: INSERT INTO T-2 year data ([Study Number 2]) SELECT [Study number] FROM...

Thanks. I'm afraid I'm too far down the road doing it this way now. I've written all the queries etc. Thank you for trying to improve it but I think it will at least work this way if I can just populate this field.

Thanks for the replies. I'm trying to work through the insert query. I know you wouldn't normally have a 1-1. The database is for a research study that has already been running for some time using excel. Table 1 is populated by uploading an excel spreadsheet, as one stage of the study is...

Sorry. I'll try again. Table 1 has a field called "Study ID" which is a Primary Key. Table 2 has a field called "Study ID 2" which is the foreign key in Table 2 and these are linked in a one-to-one relationship. So one person has information in both tables but only one row of information...

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