SQL Statment to create a Report

[TyF]

I am in the process of creating a report called "Product by Location" using
the SQL Statment. I am trying to count products by Location along with total
weight of products by location. When I click on the database icon by report
doesn't populate any data. What am I doing wrong?

 

[Duane Hookom]

From your question, it is difficult to determine what you did. Did you click
some button or menu option to create a new report? Were you able to select
your table/query?

If you didn't get that far, do you have a default printer designated in the
Windows Control Panel?

 

[TyF]

Yes, went into the properties of the report and click on record source to
create the sql.

 

[Duane Hookom]

I'm still lost. There is no "database icon" that I am aware of associated
with an Access report. Reports have a Record Source property that can be:
- blank
- a table or query name
- a SQL statement
This property has a dropdown list as well as a builder button [...] for
modifying.