Search results

I was able to achieve the results I was looking for using subreports Thank you. I achieved the header and footer structure by including headers and footers in the subreports. Thank you all for helping!

Ah completely forgot about subreports, I will look into that now thank you.

Hello all, The title says most of it, I'd like to know if there is a way to add multiple detail tabs to one report and have them separated by headers? I would like to have three sets of data on one report, each separated by a header. Is this possible or do I have to create separate reports for...

Grouping seemed to get things to work! I will post updated cleansed SQL below, and will also post an attachment with a cleansed database for clarity. To answer your question, the numbers are derived by the following, for say jon doe: status1, the query will search deliverables and count all jobs...

I will work on a slimmed down database, though in the meantime I am not quite sure what you mean by "Why isn't there EmployeeID key field in Employees and this saved as foreign key in Deliverables?" if it helps, the drop down for employee in deliverables calls the employee ID and employee name...

Thank you! I will try grouping and see if that helps! to your second point, I am not sure how I can join these two queries as they each have different data in them, though I may be misunderstanding what you mean by join in this context. To answer your last question, the status is listed...

Hello all, I have a problem trying to use an aggregate function to calculate values from a separate query. I have two separate queries, “Employees extended” and “DeliverablesPropNo” “Employees” Relevant headers: “Employee ID”, “Employee Name” “Deliverables” relevant Headers: “Job Name”...

Hello everyone, been doing Access for only a few months but looking forward to learning more about how the coding side works!