Search results

The database suddenly started working again. I didn't do anything, but it came back today as I was in the middle of fooling around with queries. I have no idea what caused it to disappear or come back.

Yes, I did play with that part. It correctly pulls up round 99, but the "Not In" is failing. But it wasn't failing before. When I play with it, it seems that I can't get any "not in" clause to work anymore.

Edit: Replacing "not in" with "not exists" doesn't work. It isn't returning the same results as my "not in" query. I don't understand why this is happening. I have a second database with an identical query and it works fine.

My table is not split, and all of the data looks completely normal when viewed in the tables.

I'm not sure what you mean by changing "round." Can you explain that more? I am not a programmer, just a self-taught Access user. On a whim, I just changed the "not in" clause to a "not exists" clause, and it works again. Why would "not in" work before but not now?

No items that anyone entered should have caused my query to stop working. The employees were working with a simple data-entry form to record the outcome of phone calls. To create the problem that I'm having, someone would have had to directly changed the query or the tables, which no one did...

No, compact and repair failed to fix the problem. I tried to import it all into a new database and the problem persists. Will I have to rebuild my entire database?

I've built a functioning database that has worked for months. Last night, while an employee was using it, three queries suddenly stopped working. I checked and all of the data still exists in the table, but queries which were fine before are suddenly failing to retrieve the data. Furthermore...

Ok, I don't think the sorting/grouping option can help me here. I want this: ID: 1 Name: Smith Phone: 444444444 55555555 I am getting this: ID:1 Wave: 1 Name: Smith Phone: 4444444 ID: 1 Wave: 2 Name: Smith Phone: 5555555

It's still not helping me. I still get a bunch of entries by wave for each subject. I want all of the phone number data from each wave in a single group for each subject, rather than multiple groups for each in wave. Am I missing some trick in the sorting/grouping function?

Can you help me more specifically with that? I'm sort of a noob to access.

I have a table of data for subjects in a research study. There have been 5 rounds of data collection, so every subject has 5 rounds of data (phone numbers, etc). I need to generate a report that shows the subjects name and ID number, and then every phone number that has been recorded for them in...