The Mudcat Café TM
Thread #47406   Message #706787
Posted By: Kim C
08-May-02 - 01:32 PM
Thread Name: tech: Access 97 Database: HELP!!!!!
Subject: RE: BS: Access 97 Database: HELP!!!!!
Thanks MMario. :-)

I have three tables of different mental health resources - counselors, psychiatrists, support groups. What I want to do is combine all that into one datasheet, sorted by category. That way, when someone calls looking for resources for depression, let's say, all anyone has to do is run the query, and all the resources will come up in one place. I thought I could do it with a query... so I set up the relationships between the tables, followed all the Wizard steps, and.... nothing. I tried building it from scratch without the Wizard, and...... nothing. Not one single record shows up at all.

I've experimented with this field, that field, taking away fields, adding fields, and....... nothing.

Is there not an Access for the Almost Totally Incompetent? ;-)

I'm sure it's some very piddly tiny thing I missed....