Trying to add a calculation in a Cross tab Query.

Hello experts,

Its me again.  I got help from a great expert on my query. (Thanks)

I am trying to do a calculation that I want to show up for a field in a crosstab query. I have This calculation :
biWhen you run it it looks like this:
BUSKIIIHelp
Then a Join query SELECT * FROM qryInstalls UNION SELECT * FROM qryBUSK;
was used so It would come out on my Crosstabquery MOD KIT field:
b3I am trying to replicate this with a Field name BUSK III and do another calculations
but for some reason it will not show up on my crosstab query.
Im not getting a error message. So Im not sure what im doing wrong.

Thanks ahead for your time and help!!!
BUSKIIIA.JPG
BUSKIIIc.JPG
HelpWithCrossTabs-rev.accdb
BIII-.JPG
gigifarrowAsked:
Who is Participating?
 
IrogSintaConnect With a Mentor Commented:
Here you go. The only thing I wasn't sure of is where you want the criteria for BUSK III Total in the qryTotalCrosstab query.
criteriaHelpWithCrossTabs-rev--1-.accdb
0
 
gigifarrowAuthor Commented:
Thank you again!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.