In Access, how do you sort a report from two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In access , how do you sort a report from two tables ( employee and overtime
) so that your report will only show one employee and all it s hours worked
in overtime . Thank you ! ( i'm new to access !!!! )
 
Access reports lose all sorting set in a query that's the record source.
Click on the Grouping and Sorting button on the toolbar at the top of the
screen when your report is in design view. Set to group on Employee and sort
OverTimeDate descending. Put your Employee field in the Employee group
header in the report and your OverTimeDate and OverTimeHours in the detail
section.
 
Thanks PC Datasheet ...

Al

PC Datasheet said:
Access reports lose all sorting set in a query that's the record source.
Click on the Grouping and Sorting button on the toolbar at the top of the
screen when your report is in design view. Set to group on Employee and sort
OverTimeDate descending. Put your Employee field in the Employee group
header in the report and your OverTimeDate and OverTimeHours in the detail
section.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Click to expand...
 
Al,

I am in business to provide customers with a resource for help with
Microsoft Access, Excel and Word applications. You can view my website at
www.pcdatasheet.com. If you ever need outside help, contact me at my email
address below.
 
Back
Top