Prev: Auto number
Next: Microsoft Word Table design in Access 2007
From: SSi308 on 18 May 2010 10:19
How does the table know who the record is for when running reports?
For example the ContractsAndHours subform was created from the
ContractsAndHours table. If I do a query on the ContractsAndHours table
information and there is no name field how do I sort by employee name?

Thanks for the reply it is very much appreciated.

"Arvin Meyer [MVP]" wrote:

> You don't ever need to store the name in 2 places. The only data that should
> ever be duplicated is the key.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.accessmvp.com
> http://www.mvps.org/access
>
>
> "SSi308" <SSi308(a)discussions.microsoft.com> wrote in message
> news:8397B7AC-C8C5-4B9F-A57C-F2A1FF726AA9(a)microsoft.com...
> >I have a form called ContractsIn which has a subform called
> > ContractsInAndHours.
> > The main part of the form consists of:
> > Employees.ID
> > Employees.Name
> >
> > The subform has the fields:
> > ContractsAndHours.ID
> > ContractsAndHours.Name
> > ContractsAndHours.DailyHoursWorked
> > ContractsAndHours.ContractOut
> >
> > This form is used by the supervisor to enter the hours worked and the
> > contracts in for each day.
> > When entering hours and contracts for each employee I would like the Name
> > field in the subform automatically filled in with the name in the main
> > form
> > when entering through the field.
> >
> > Can this be accomplished?
> >
>
>
> .
>
From: John W. Vinson on 18 May 2010 12:57
On Tue, 18 May 2010 07:19:01 -0700, SSi308 <SSi308(a)discussions.microsoft.com>
wrote:

>How does the table know who the record is for when running reports?
>For example the ContractsAndHours subform was created from the
>ContractsAndHours table. If I do a query on the ContractsAndHours table
>information and there is no name field how do I sort by employee name?

Join the Employees table in the query: pull the contract and hour information
from the ContractsAndHours table, and the name from the Employee table. That's
what relational databases DO - let you combine data from multiple related
tables into one result.

If you're assuming that the Report must be based on a single table containing
all the needed information, you're missing the real power of databases!

--

John W. Vinson [MVP]
From: Arvin Meyer [MVP] on 18 May 2010 21:39
You use a query to sort and the EmployeeID to identify the employee. A join
on EmployeeID from the employees table will display a name.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"SSi308" <SSi308(a)discussions.microsoft.com> wrote in message
news:71EA33BC-6735-4070-992F-AB358D2DE57E(a)microsoft.com...
> How does the table know who the record is for when running reports?
> For example the ContractsAndHours subform was created from the
> ContractsAndHours table. If I do a query on the ContractsAndHours table
> information and there is no name field how do I sort by employee name?
>
> Thanks for the reply it is very much appreciated.
>
> "Arvin Meyer [MVP]" wrote:
>
>> You don't ever need to store the name in 2 places. The only data that
>> should
>> ever be duplicated is the key.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.accessmvp.com
>> http://www.mvps.org/access
>>
>>
>> "SSi308" <SSi308(a)discussions.microsoft.com> wrote in message
>> news:8397B7AC-C8C5-4B9F-A57C-F2A1FF726AA9(a)microsoft.com...
>> >I have a form called ContractsIn which has a subform called
>> > ContractsInAndHours.
>> > The main part of the form consists of:
>> > Employees.ID
>> > Employees.Name
>> >
>> > The subform has the fields:
>> > ContractsAndHours.ID
>> > ContractsAndHours.Name
>> > ContractsAndHours.DailyHoursWorked
>> > ContractsAndHours.ContractOut
>> >
>> > This form is used by the supervisor to enter the hours worked and the
>> > contracts in for each day.
>> > When entering hours and contracts for each employee I would like the
>> > Name
>> > field in the subform automatically filled in with the name in the main
>> > form
>> > when entering through the field.
>> >
>> > Can this be accomplished?
>> >
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Auto number
Next: Microsoft Word Table design in Access 2007