Search results

PROBLEM SOLVED! well mostly, apparently you can't have two source tables in the little holding area (in append query design view) even if just one of them is selected below, because access will decide to use the data from the selected table but multiply the number of records produced by the...

well the problem appears to be fixed, but I don't get why... In the design view I had an additional table in the area that shows tables you can select for appening from, but only one was actually selected for all of the fields, the other one was a new dataset. Why would having another table...

this question originated in the table forums but has turned into a query problem. basically I am trying to append query 13 fields (out of 48) of 19 records, because I get data sheets (lab results) that look the same every time but with unique data, and I only want to append 13 of those...

I seem to have fixed the rounding problem by changing the field size to double instead of decimal, but that was trial and error not an educated decision. A typical field (with heading) looks like this: SiO2 (%mass) 2,94 We use commas rather then decimals in Germany, the program knows this...

Thank you, thats a very helpful start. I've encountered a few problems though. 1. All of my data got rounded to the nearest decimal in the append destination table! not good 2. When I try to import a new temp table and append that to the destination table, I have to go back into the append...

I am extremely new to access, I have an internship with a large company and they thought I should work on their lab results database since they couldn't find anything else for me to do. They don't seem particularly concerned that I have no experience with Access, apparently letting me struggle...