472,353 Members | 1,695 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

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 1745

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Megan | last post by:
hello everybody, i know this is a very long post, but i wanted to provide as much detail as possible. quick overview- i want to create a...
by: Jack Schitt | last post by:
I thought I was starting to get a handle on Access, until I tried doing something useful...now I'm stuck. I have a DB with two tables - to keep it...
by: davegb | last post by:
I'm totally new to relational database design. My boss has asked me to create a database of information on the employees in our group. Seemed to me...
by: Dixie | last post by:
I need to delete some relationships in code. How do I know what the names of those relationships are?
by: salad | last post by:
I'm curious about your opinion on setting relationships. When I designed my first app in Access I'd go to Tools/Relationships and set the...
by: alexandre.brisebois | last post by:
Hi, I am using access 2003, I would like to know if there is an option to reorganize the tables in a maner that is readable, as we can do in sql...
by: Sam | last post by:
Hi, I have one table like : MyTable {field1, field2, startdate, enddate} I want to have the count of field1 between startdate and enddate,...
by: Shogun | last post by:
I have an mdb with a *projects* table. I also have a *timecode* table. Projects and timecodes are related by a one-to-one relationship but I...
by: Phil Stanton | last post by:
Sorry to repost this but I now seem to have the BE datbase corrupted. I have a FE, BE database on my home computer and a duplicate on the office...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.