Search results
-
E
acImportFixed
I am currently using a (DoCmd.Transfertext acImportFixed, "specification name", "table name", "source file", true) statement to bring in data. I've been using it for several months and I thought it was working fine. Today I realize that in the event the input file only has 1 line of data in... -
E
Select and group by 2 fields
No, this did not work for me actually. All it did was eliminate the duplicate X's, and then assign the first value for Y that appears to the 1 X it kept. What I want is a query that identifies every instance where X is the same BUT Y is different. I don't care about entries where X is the... -
E
Select and group by 2 fields
Hello, I have a table setup where X = Identifier Y = Data The identifier is not unique in this case, as the table is loaded with a history of all possible Y values for each X. My goal is to write a query which groups the data by X but only where Y is different (if the Y is the same across...