468,776 Members | 2,011 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,776 developers. It's quick & easy.

Help with Relationships - Query and Table relationship

I am trying to design a query that works with a relationship between a
Table and a Query. I am comparing a value in the table with a computed
value inside the query.

The reason for this is that the Query calculates a field to become
identical to the corresponding table field, for instance:

Table 1 contains field "ID", which is WV008A00
Table 2 contains field "ID In", which is WV001000

In the query I created, I am using a function that converts Table 1's
ID to look identical to the records in Table 2. Namely, changing the
'8' to a 1' and the 'A' to a '0'. Let's call this Query calculation
field "FormattedID"

Now, I need to relate the Query calculation field "FormattedID" with
Table 2's "ID In" field and bring results from both tables.

If I make a relationship in the Relationships window between
"FormattedID" and "ID In", the properties window for that relationship
is very limited. Everything is greyed out and the only property I can
change is the 'Join Type' button.

Also, after relating the query and table and running my new query, it
will return every record from the calculation query for EVERY record in
Table 2. For instance, if Table 2 returns 2000 results and the
calculation query returns 20, my new query generates 40,000 results.

Any help in what direction I should be taking with this would be most
appreciated. Also, I am fairly new at Access, but not VB programming.

Nov 13 '05 #1
0 1581

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by Jack Schitt | last post: by
7 posts views Thread by davegb | last post: by
4 posts views Thread by alexandre.brisebois | last post: by
5 posts views Thread by Sam | last post: by
reply views Thread by Phil Stanton | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.