Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paradox tables and sub-reports

Status
Not open for further replies.

corner40

Technical User
Nov 20, 2002
126
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top