On 8/29/06, Don Parris <[EMAIL PROTECTED]> wrote:
On 8/29/06, Don Parris <[EMAIL PROTECTED]> wrote: > > > Biz_id (PK) > BizName (Text) > Active (Boolean) > > On 8/29/06, Andrew Jensen < [EMAIL PROTECTED] > wrote: > > > > *Chuckling*...ok, it's been a long day. > > > > Try this one last time. > > 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? I can't get Base to let me establish a relationship between tbl_BizContact.biz_id and tbl_Survey2006.biz_id. Anyway, I'm much happier now that I can look and see where I stand with my data. :-) Thanks for all the help.
