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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IrogSintaCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gigifarrowAuthor Commented:
Thank you again!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.