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 :
When you run it it looks like this:
Then a Join query SELECT * FROM qryInstalls UNION SELECT * FROM qryBUSK;
was used so It would come out on my Crosstabquery MOD KIT field:
I 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
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 :
When you run it it looks like this:
Then a Join query SELECT * FROM qryInstalls UNION SELECT * FROM qryBUSK;
was used so It would come out on my Crosstabquery MOD KIT field:
I 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER