Search results for query: *

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...

...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 (tblCalKeyStack.LEVEL = tblPolyKeyStack.LEVEL) AND (tblCalKeyStack.HI_GRD =...

...of records grouped in table 2 is what essentially replicates the regions from table 1. The first table has: Group_ID (region based) Item_ID * LowGrade * HiGrade * Type * Name * Range * *duplicate combinations of these fields may exist among multiple groupings. The second table has...

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

Hi, I have one table that has records which can be grouped by like values in a field. I have another table that also has records that can be grouped by like values in a field. I am able to create separate reports with each of the tables that display these groups. What I am trying to do is to...

The First tab that should open the homepage says: "Connecting..." I installed an update that seemed to fix it last night, and now its the same old thing: "Connecting" Anyone seen that? Thanks again! Joe

Hi, Does anyone use the Backup Utility that comes with XP Pro? I just backed up about 150GB and some folers have a RED EXCLAMATION POINT by them. What does that mean? I've been looking in the help file and the windows web site... If anyone knows, Thanks!! Thanks again! Joe

Hey there folks, I'm now trying to qualify on a type field to include records to include in the FindLabel function.... Function FindLabel ( [NAMEA-ALF], [TYPE] ) if ( [TYPE] <> 2000, 2100, 2200, 5500, 5600) FindLabel [NAMEA-ALF] end if a = split( [NAMEA-ALF] , " ") for...

Why would I get an error about the number of tables being opened? I only have 3 tables in the whole DB and am only working with 2 of them?? See previous post......... Thanks again! Joe