matching a field from two table

[mohsin via AccessMonster.com]

Hi there

Hope you guys can help me, for this conditions;

From "referrence" database i have a numbers which have a range and need to
match to result database i can call "to match" table to get the real
conditions.

For example, from referrence database i have 5429150&-4(number (from 0 to 4)
and from "to match" table the filed is 5429152,. Logically it will not match,,


But still have other's way to do.

-tq for your help

 

[Jeff Boyce]

Mohsin

I'm not sure I'm understanding ...

Are you talking about "databases" (entire Access .mdb files) or "tables"
(the objects that hold data in Access files)?

If you are talking about tables, how does your "reference" table hold "a
range"? Is that a single text field or a pair of numeric fields (low value,
high value)?

What field type is the comparison value in the other ?table?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[mohsin via AccessMonster.com]

Hi

Is in table. Both is in text type format although is a number.
Yes from "Reference" is a range, but in one single field, for example
CALL ID (field) = 5429150&-4 (text format)

then in the "to match" table
DIGITs(field) = 5429152 (text format)

Mohsin

I'm not sure I'm understanding ...

Are you talking about "databases" (entire Access .mdb files) or "tables"
(the objects that hold data in Access files)?

If you are talking about tables, how does your "reference" table hold "a
range"? Is that a single text field or a pair of numeric fields (low value,
high value)?

What field type is the comparison value in the other ?table?

Hi there

[quoted text clipped - 10 lines]

-tq for your help

 

[Jeff Boyce]

mohsin

My first suggestion would be to remove the range of values from a single
field and use two fields (LowValue, HighValue). Having more than one fact
in one field violates one of the cardinal rules of database design, and
leads to problems like what you describe!

Once you have a true range (two fields), you can use a query to find
[DIGITS] that are between [LowValue] and [HighValue].

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hi

Is in table. Both is in text type format although is a number.
Yes from "Reference" is a range, but in one single field, for example
CALL ID (field) = 5429150&-4 (text format)

then in the "to match" table
DIGITs(field) = 5429152 (text format)

Mohsin

I'm not sure I'm understanding ...

Are you talking about "databases" (entire Access .mdb files) or "tables"
(the objects that hold data in Access files)?

If you are talking about tables, how does your "reference" table hold "a
range"? Is that a single text field or a pair of numeric fields (low value,
high value)?

What field type is the comparison value in the other ?table?

Hi there

[quoted text clipped - 10 lines]

-tq for your help