I have a report that runs off of a crosstab query. The three column headings from field SETSTAT are "cancelled" "closed" and "pending" The issue is that sometimes a company wont have any "cancelled" or otherwise, but since "cancelled" is a...
THis is the field from the table.
PURCREFI
pur
refi
refi
pur
pur
refi
so I am getting a count by company of how many purchase and how many refinances they had. So some have no purchases or no refinances, like in the table two posts up, but the zero isn't there. There are no null in the...
when I NZ(...) in the control source i.e. NZ([purchase],0)
I get the #error. When I use the function in the query it has no effect. Here is an example
Purchase Refinance Total
3
1 5 6
3
So you can see what the problem is now. I...
I have a report that runs off of a crosstab query. the column headings are "purchase" and "refinance". I want to have a total column next to that, if purchase or refi column equals zero, the report leaves it blank and
=[purchase]+[refinance] will not show anything. I...
Disregard above post!!!!
I got it to work. Thanks so very much shannonp, ive been working on this one for a while and this is a huge help.
THanks again,
Dave
Shannonp1, I have the same problem as ahmun, but what works for you didnt work for me. I have a form with three fields, 2 of which are are numbers for a between
form![field1] and form![field2], and then a sales person form![txtSales]
when i add these to the query parameters
Between...
I have the same problem. It seems that this problem is unique to crosstab queries, because if you remove the TRANSFORM and PIVOT from the SQL, it runs fine. Saving it to a table won't work either. I have been working on this one for a while, and by the lack of responses, I assume no one...
I have the same problem. If you remove the TRANSFORM and PIVOT it will probably work, but then it isnt crosstab anymore. I haven't been able to figure this out and it is bugging me too.
Dave
My guess is you are using a crosstab query. If you change it to a select it will work. I have a similar (or perhaps the same) problem. I try to pull criteria from a simple form into a crosstab to create a report. It says that MS Jet does not recognize Frm![..] as a valid field name or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.