E
Emilio
(MS Access 2002)
Hello, I'm working with some big Census (PUMS) files, and I run into a
peculiar problem once the data field exceeds five integers. I'll explain
every step, since I am doing it in a somewhat complicated manner.
1. I filter the data to include only those serial numbers (field name) that
include a specific value in another field.
2. Those serial numbers are exported into Excel, where it's easier for me to
work the formulas. I then filter the serial numbers even more, and re-import
them as a table into MS Access.
3. I create a Relationship between those two tables (the original large file
and a table which is just a list of the filtered serial numbers I need). The
Join Properties are to include all records from the table with the filtered
serial numbers.
4. I create a query. The result is that all serial numbers which are 5
integers or less, coincide, as they should. However, when the serial number
has six integers, some records coincide, others do not. They should all
coincide, since the defining serial numbers were extracted from the original
table. But the query between both tables is only capturing some serial
number records that coincide from the original table, when it should capture
every single one of them. (The way I've figured this out is by putting both
in the same query and comparing)
I've deleted the databases, started from scratch in three of them, and the
problem keeps reproducing.
In the original table design, the field type for serial number is long
integer.
Any help will be appreciated. Let me know if you need more details.
Thanks.
Emilio Guerra
Hello, I'm working with some big Census (PUMS) files, and I run into a
peculiar problem once the data field exceeds five integers. I'll explain
every step, since I am doing it in a somewhat complicated manner.
1. I filter the data to include only those serial numbers (field name) that
include a specific value in another field.
2. Those serial numbers are exported into Excel, where it's easier for me to
work the formulas. I then filter the serial numbers even more, and re-import
them as a table into MS Access.
3. I create a Relationship between those two tables (the original large file
and a table which is just a list of the filtered serial numbers I need). The
Join Properties are to include all records from the table with the filtered
serial numbers.
4. I create a query. The result is that all serial numbers which are 5
integers or less, coincide, as they should. However, when the serial number
has six integers, some records coincide, others do not. They should all
coincide, since the defining serial numbers were extracted from the original
table. But the query between both tables is only capturing some serial
number records that coincide from the original table, when it should capture
every single one of them. (The way I've figured this out is by putting both
in the same query and comparing)
I've deleted the databases, started from scratch in three of them, and the
problem keeps reproducing.
In the original table design, the field type for serial number is long
integer.
Any help will be appreciated. Let me know if you need more details.
Thanks.
Emilio Guerra