Recent content by Joeclueless

I'm going to need to get back to this tomorrow. I'll create better examples or Attach sample tables... Which do you think is better? Thanks again! Joe

Need to collect myself... Just had experienced an Earthquake! Thanks again! Joe

This returns a syntax error in FROM clause... Thanks again! Joe

I'm soooo sorry.... I forgot about those extra records in the sample..... Yes, they should be included.... I will try this right now... Thanks again! Joe

PHV, That did not quite work... But look at the sample I posted for lespaul. if the return looked like this, it may work: POLYID CalKeyStack SCHOOL_ID LO_GRD HI_GRD LEVEL 1 A 1234 0 5 E 1 A...

Thanks for bearing with me Leslie! tblPolyKeyStack POLYID SCHOOL_ID LO_GRD HI_GRD LEVEL 1 1234 0 5 E 1 4582 6 8 M 1 8564 9 12 H...

Leslie, Right now what I have are two reports that are grouped on the ID fields. What I want to do is compare the groupings and transfer the POLYID value from tblPolyKeyStack to the matched set of records in CalKeyStack. So, Maybe what I need to do is have a report with a subreport. The main...

Leslie, thanks for letting me know that I am not communicating my dilemma effectively.... Sorry for any vague descriptions.... Here are the samples: tblPolyKeyStack Sample POLYID SCHOOL_ID LO_GRD HI_GRD LEVEL] 1 1234 0 5 E...

If possible, could someone let me know if they understand what I mean by matched record groupings and how they differ from matched records? Thanks again! Joe

I should have said matching up exact groupings would be a GREAT start. Does this rewording shed light on the difference I am trying to emphasize? Thanks for all posts! Again, tblPolyKeyStack is grouped on POLYID and tblCalKeyStack is grouped on CalKey. These two fields have nothing in...

Hey, The fields combined don't really make it unique. Many records in many groups have the same combination in both tables. The unique thing is the combination of records that are grouped by [CalKey] or [POLYID]. As for the question of dropped fields, the Code field [tblCalKey.ZeroCode] is...

Well, I fixed up my tables to eliminate reserved words.... so I now have the code snippet modified to match. I am getting different results that I expected. Here is the query code: SELECT tblCalKeyStack.*, tblPolyKeyStack.* FROM tblCalKeyStack INNER JOIN tblPolyKeyStack ON...

Hey, Thanks Tyrone, but I suppose I need to get into deeper details. There is a spatial element to this data, that exists in only one of the tables. The group ID in that first table is based on those regions. The second table, that I want to transfer the region IDs to, has similar info...

Tyrone, Here is the thing, there is no common field. The groupings should have equal and similar records, but I am wanting to pass the ID from one group to the other... The first table has: Group_ID Item_ID LowGrade HiGrade Type Name Range The second table has: Group_ID (different from...

Thanks Tyrone, What if the IDs in the two tables are not the same? Thanks again! Joe