Search results for query: *

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...