Create One Report from one Query with multiple parameters

[trock12]

Hopefully the title makes sense. I have a query that uses 2 parameters - User, and a date range Start Date thru End Date.

When you run the query as a standalone, you would input the User's Name, then Start Date and End Date to get the desired information.
There are 14 users. I'm hoping to create 1 report, with a separate section for each user - all for the same variable of date range.

The goal is to just run the report, type in the date range, and have it populate a section for each user with the returned query information.

I'd have to think there is a simple solution to this that doesn't involve make a "Pre-Made" query for each user, and then entering in the date range 14 separate times to generate the report.

Any help would be appreciated!

 

[trock12]

Sorry for the delay in response. The primary key in tbl_user, is linked in the tbl_info_added. So when I look at the table records in tbl_info_added for "username", it gives me the primary key for the user that was selected. I have to go to the tbl_user table to see that 1 corresponds to Jack Smith.

When I use the above CStr addition, I don't get all the information. For example, Jack Smith entered info on 2/18/2016, so he should not pull on the query, yet it does. It looks like it's just pulling the same information for the first query, but within the date range.

 

[trock12]

I seem to have figured it out -

Thanks so much for the help

 

[xenou]

Great. Glad it's working now.