data summary 1

[brews]

Am using CR 9 with VB6.

Trying to run a grand total on numeric fields and all I get when inserting is the Maximum, Minimum, Count, distinct Count, and Nth fields to insert. How do I get to the Sum format?

When I right click on the field there is no tab for Numbers. How to change?

First time I've run into this puzzler. Guess I've been luck.

Thanks for the help.

 

[brews]

Here's a discovery. If the data is not being manipulated numerially such as fld1/10 AS Number where fld1 is designated as integer, then all is ok in CR land. However, my problem is how to format/reformat data that is manipulated?

Thank you.

 

[lbass]

What is the exact formula you are using?

-LB

 

[brews]

something as simple as IIF(field1<>0,field1/10,'') AS xyz. If, however, only field1/10 is used then it shows up as expr0001. Kinda sloppy, but it works.

Any other way of doing it?

thanks

 

[lbass]

It looks like your field isn't a number, but instead, a string--otherwise the IIF would fail when "" is the alternative. Also, it appears you are creating this in a command. If you convert it to a number, you will be able to sum it.

-LB

 

[brews]

thank you. The field is a number but I was mixing data types. Changed the '' to NULL and now it works.

You mentioned that it was created in a command. What are the consequences of that? thanks.

 

[lbass]

No particular consequences--it's just that the syntax available in a command for conversion can be different than in a formula area.

-LB

 

[brews]

On another issue. How to set the width/height of the CR form when it opens? Seems I forgot and can not find the answer.

Thanks

 

[lbass]

When you have a new topic, you should start a new thread. Not sure what you mean by "form." To set the margins, go to file->page setup. If you mean in VB, I don't know.

-LB