Subreport from union query

[gump]

I have 2 queries, one a standard select query showing all time posted by
employees for a set time period, the other a union query showing all projects
the employees are team members on and the estimated hours for each project.
Common field between the two is NAME, which is an expression joining First
Name and Last Name fields from the Employee table. I would like to create a
report / subreport to show information from both but even after selecting
"NAME" as the join field my subreport always appears empty.

 

[Duane Hookom]

"Name" is not a good name to name anything in Access that has a Name property
which is basically everything. I expect [Name] is returning the Name of your
report rather than the column you haved named Name. Change your derived
column name to FullName.

 

[gump]

Perfect, thank you. I didn't realize that.

"Name" is not a good name to name anything in Access that has a Name property
which is basically everything. I expect [Name] is returning the Name of your
report rather than the column you haved named Name. Change your derived
column name to FullName.
--
Duane Hookom
Microsoft Access MVP

I have 2 queries, one a standard select query showing all time posted by
employees for a set time period, the other a union query showing all projects
the employees are team members on and the estimated hours for each project.
Common field between the two is NAME, which is an expression joining First
Name and Last Name fields from the Employee table. I would like to create a
report / subreport to show information from both but even after selecting
"NAME" as the join field my subreport always appears empty.