Can you help me with this query?

T

Terri

You can make a query that pulls from both tables. (Relate
the tables by clicking and dragging the question ID from
one to the other)While in the design view click on totals
under Veiw in the toolbar. Choose "group by" for the
street column and "count" for the answer column, then
specify the answer wanted in the criteria of the answeer
column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top