Make a Crosstab Query from a Query containing a Subquery (1 Viewer)

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


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 |
+-----+----------+----------+----------+----------+----------+
 

Attachments

  • HBMHR.zip
    352.3 KB · Views: 194

theDBguy

I’m here to help
Staff member
Local time
Today, 07:08
Joined
Oct 29, 2018
Messages
21,358
Hi. Just curious, can you post a link to where you read that?
 

raziel3

Registered User.
Local time
Today, 10:08
Joined
Oct 5, 2017
Messages
273
I was reading this link


Essentially on posts with similar problems, they were suggesting to remove the subquery altogether.

Like these

 
Last edited:

Pat Hartman

Super Moderator
Staff member
Local time
Today, 10:08
Joined
Feb 19, 2002
Messages
42,983
I rarely use subqueries because the Access query engine doesn't optimize them well. Try making the subquery a separate query and then join to that query.

I know this works with Crosstabs.
 

Users who are viewing this thread

Top Bottom