Hi Don, >>O.k., I think I know the source of the problem now. My db consists of 2 >>tables. When I remove the 'survey2006' table, I get proper counts from >>tbl_BizContact. When I add tbl_survey2006, that's where things go goofy. > > Well, I just tried running the query on each table independently with great > success, just using the standard query design mode. I don't exactly know > why I couldn't pull a field from each table, but would that have anything to > do with the relationship between the tables?
A "SELECT <something> FROM <table1>, <table2>" creates a cartesian product between those two tables. That is, it will have n*m rows, when n and m are the number of rows of in the single tables. That's why this high numbers in your results. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
