Question on no data reports and numeric fields

[KenHigg]

Sorry - don't see that text string in any of your posts.

I suggest you step through your code to find the offending syntax...

ken

 

[yessir]

I am wondering if there was ever a solution found for this?

I tried a couple of the things mentioned on this thread and i got the same #error and #name.

 

[KenHigg]

Can you elaborate?

ken

 

[yessir]

well I have a report based on a crosstab query.

which looks like

date EN-02 EN-04 EN-05
====================
1/1/02 ....

but if there is no value in the query for EN-02, 4 or 5 then there is no control source for the report for those textboxes.

so i tried the nz() and val(nz())
but they return #error and #name...

How can I get the textbox to display "No flow" instead of throwing an error that it cannot recognize [EN-02] as a valid entry

 

[Rich]

Please don't post the same question in more than one post.

The NoData event is not the same as no data in a CrosstabQuery, either define the columns in the query property sheet or use a Dynamic Cross tab

 

[KenHigg]

After you get your crosstab, could you do a second query based on it and put you nz() there?

???
ken

 

[yessir]

I was asking about the nz nad if(is null no the hasnodata

he asked to elaborate and i did

and i don't understand the what you mean by:

define the columns in the query property sheet

how would this solve the problem of no control source for the report and how would i do it?

(sorry, this isn't to offend)