If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Should I base my report on a form or a query?
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! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
#3
|
|||
|
|||
Should I base my report on a form or a query?
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 -- Duane Hookom Microsoft Access MVP "Nancy via AccessMonster.com" wrote: 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! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 . |
Thread Tools | |
Display Modes | |
|
|