Should I base my report on a form or a query?

[Nancy via AccessMonster.com]

I've created a database for a project at work that will track production and
piece work. I've started with two tables: Employee Data and Weekly Data.
These two tables contain the information that supplies my Form (also called
Weekly Data) with the data it needs to pull from. This form allows
supervisors to enter in daily production data for each employee. They enter
in the employee's clock number and it automatically generates the employee's
name (which is pulled from the Employee Data table.) The code I used in the
employee's name text box is: = [Clock Number].Column(1)

Now I am trying to generate a report from the Weekly Data form. I created a
report based on the form, but when it shows the information that I entered,
it only shows the employee's clock number and not the name on the report. I'm
assuming this is because there is actually no data entered into that box, it
is just generated. I also tried creating a query using both tables as the
foundation and linked the tables at the appropriate sources but when I open
the report it shows no data from my Weekly Data form.

So what is the best way to make a report that shows data from the Weekly Data
form (including the employee's name which is automatically generated)? Thanks
in advance for any suggestions!

 

[Steve]

Hello Nancy,

Based on your description, It does not sound like your tables are designed
correctly. Before tackling the problem you think you have, you need to have
your tables st up correctly. Please post the fields in each of your tables
and we will review what you have and offer suggestions if needed.

Steve
(e-mail address removed)

 

[Duane Hookom]

Why not continue the thread you started yesterday where Marsh is providing
excellent assistance. When you reply to Marsh, please keep in mind that forms
don't have data, they only display data from tables or queries. Your report
should be based on a query.

Post the SQL view of your report's record source query back in the other
thread. Then provide the Control Source of the control that doen't work as
expected. I think this control source simply needs to be a field name from
your record source.

Also, please do yourself a favor and use a standard naming convention. I
would find two different objects sharing the same name (Weekly Data) very
confusing. Consider removing spaces from objects names so you might end up
with:
tblWeeklyData
frmWeeklyData