I have a couple of paradox tables that I'm linked to in access...one has a primary key defined, the other doesn't...I know that access sometimes has some problems when there isn't a primary key defined in paradox tables...so this is what is happening to me...I have some queries that break up the tables into the groupings that i need and they work fine...I have some sub-reports generated by the queries that work fine individually but when I go to combine them into one report I get problems...I get an error saying that "operation not supported by paradox table without primary key"...the weird part is that the first sub-report shows up no problem and then the error messages happen, one for each additional sub-report...so my question is has anyone had a problem with this before...I can't give the one table a primary key at all, so that's out of the question...I need to combine the sub-reports so that I can do some calculations with the totals of each report...any help would be great thanks...
Jeremy
Jeremy