raziel3
Registered User.
- Local time
- Today, 10:08
- Joined
- Oct 5, 2017
- Messages
- 273
I read on some of the forums that once your source query have a subquery in it you will not be able to make a crosstab query.
How can I get around that? In the attached db I want to create a crosstab query from the query qryWKLYHRS that would look like this
How can I get around that? In the attached db I want to create a crosstab query from the query qryWKLYHRS that would look like this
Code:
+-----+----------+----------+----------+----------+----------+
| EID | 1/1/22 | 8/1/22 | 15/1/22 | 22/1/22 | 29/1/22 | <---- WKEND
+-----+----------+----------+----------+----------+----------+
| 13 |$1,684.62 |$1,684.62 |$1,684.62 |$1,684.62 |$1,684.62 | <----GROSS
| 14 |$1,338.04 |$1,279.46 |$1,335.70 |$1,462.24 |$1,567.69 |
+-----+----------+----------+----------+----------+----------+