Hello Guy's
I have another challenge to accomplish and could use some help.
I attached an excel document that mimics the form and report I need to create. (I made it pretty clear where the data was coming from).
The data is coming from a few different places.
Points table, Non_Standard_Actions table, Query1 for counting the standard actions.
I made three queries that get the data I need: PointsQuery, NSATotByWeek Or NSACrosstabTotByWeek, and CountAllSAByWeek.
Now I have no idea how to combine all the data into a form or report. I uploaded the database to google drive, it's too big to upload here. The UserID that I have been using for testing is UserID=2 (Holly Flowers). That's the only one that has all the points for all 12 weeks. All data is fictitious for testing purposes. Here's the link
I tried to make my needs pretty clear, but please ask as many questions as you need.
Thanks
I have another challenge to accomplish and could use some help.
I attached an excel document that mimics the form and report I need to create. (I made it pretty clear where the data was coming from).
The data is coming from a few different places.
Points table, Non_Standard_Actions table, Query1 for counting the standard actions.
I made three queries that get the data I need: PointsQuery, NSATotByWeek Or NSACrosstabTotByWeek, and CountAllSAByWeek.
Now I have no idea how to combine all the data into a form or report. I uploaded the database to google drive, it's too big to upload here. The UserID that I have been using for testing is UserID=2 (Holly Flowers). That's the only one that has all the points for all 12 weeks. All data is fictitious for testing purposes. Here's the link
I tried to make my needs pretty clear, but please ask as many questions as you need.
Thanks