Subreport from union query

  • Thread starter Thread starter gump
  • Start date Start date
G

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.
 
"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.
 
Perfect, thank you. I didn't realize that.

Duane Hookom said:
"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


gump said:
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.
Click to expand...
Click to expand...
 
Back
Top