Query for Report

[nutmeg]

Hello,



I'm a new user and having trouble completing a case for a university information systems class.

The project includes creating a customer table and a product table, and creating various queries & a report.

One query problem is to create a query to list all products that have been ordered by a given number of customers (in this case, 30).

We successfully did that by doing this (deals are products and signups are orders).

Here is a picture of the design view and here is the SQL view: (the instructions noted for only Deal # and Description to be visible)

 SELECT [Deal Table].[Deal #], [Deal Table].Description
FROM [Deal Table] INNER JOIN [Signup Table] ON [Deal Table].[Deal #] = [Signup Table].[Deal #]
GROUP BY [Deal Table].[Deal #], [Deal Table].Description
HAVING (((Count([Signup Table].[Deal #]))>30));

Our problem that we can't figure out is that we have to take the results from this data and create (1) a query to output the description of each deal and the names of customers signed up for the deals that have over 30 orders and (2) generate a report from the query and group records based on the description field.

When we add customer names and emails to the design view, no data shows up in the datasheet view, and we get various error messages when trying to tweak it.

This is a screenshot of the example in the assignment.

Thank you for any help or ideas you can offer!

[June7]

Try doing a query that joins the first query to the Signup table

BTW, advise not to use spaces, special characters, punctuation (underscore is exception) in names.

[nutmeg]

Try doing a query that joins the first query to the Signup table

BTW, advise not to use spaces, special characters, punctuation (underscore is exception) in names.

Thanks for the feedback.. But I have no idea how to do that, if you could provide some details I would really appreciate it! Thank you

[June7]

Use query designer. Drag the query and the Signup table to the query designer window, join on the common Deal # fields, drag fields to the design grid. Access Help has guidance on using the designer. Basic Access functionality.