Search results

The query wasn't the problem. I had a relationship between my client IDs and they were set to double instead of long integer. Once I changed that in my original DB everything appended correctly.

Wow that was it!! Thank you so much!! Can you explain why that caused so much of a problem?

I've tried the date/time format, but I couldn't get it to ever transfer correctly from excel without having to retype it all because I did not create the original data. I have the calculated fields because I use them for other queries and reports.

Apologies, here is a copy that matches the DB

Ok I randomized the data now.

Yes I'm trying to randomize the data so I can just send everything.

I have 2016 Ok this really doesn't make sense because it does work on the copy, but not the original. So something I changed must be causing the problem.

Ok I actually created a copy of my database and removed a bunch of thing and consolidated the information.

I can't really send the DB due to HIPPA violations (I work in a hospital setting). However, I have looked up the indexes and there is nothing indexed.

I'm fairly new to Access and I'm trying to build a client admission DB for my company by condensing an excessive amount of spreadsheets. I have a table where I'm compiling all the data, a linked table to an excel sheet where I manipulate past data, and created an append query. Every time I run...