Link to home
Start Free TrialLog in
Avatar of gigifarrow
gigifarrow

asked on

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 :
User generated imageWhen you run it it looks like this:
User generated image
Then a Join query SELECT * FROM qryInstalls UNION SELECT * FROM qryBUSK;
was used so It would come out on my Crosstabquery MOD KIT field:
User generated imageI 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
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gigifarrow
gigifarrow

ASKER

Thank you again!!