Problem importing and querying after five integers (MS Access 2002)

[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

[Arvin Meyer]

Check to make sure that the reimportation of the numbers into Access is not
creating a datatype of Double.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Emilio" <eg******@bellsouth.net> wrote in message
news:ab*************@bignews4.bellsouth.net...

(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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/2003