Recent content by powerprinting

I have a field that is character containing dates... Ex: 19991102 I want to convert this to a date field... whats the proper syntak to convert this field to another fields of proper date?

Thanks Mike, that should work better

I think I solved my own problem. I used set filter to isblank(payoff)... only blank records are showing. Hopefully this is my best way. Thanks

I have a numeric field my database. The data is populated with any number from 0 on up. However, sometime the field is blank, containing no numbers at all. What syntak will isolate the blank records. Everything I try to do evalutes the blank record as being a 0. I dont want a 0 in that field...

thanks

ahhh.. you were right, I didnt select count in calculate field... seems to be fine now.. you have been patient.. thanks. Now I know how to do this...

varible = cnt value to store = 0 initial value = 0 calculate = nothing

I did... I tied the varible to the BOX... not the data. The shade box in the form I added.. print when mod(cnt,2)=0 however, each line is shaded... not every other one In the BOX is the print when varible

Getting closer!!! I removed any refrence to the varible in print when in the data detail. The shade box in the form I added.. print when mod(cnt,2)=0 now, each box is shaded. Not zebra.. I must be missing one addition element.. but dont know what. each line is shaded. I I put mod(cnt,2)=1...

yes, Zebra is what I want.... from what you say, I am putting the varible in with the data fields and need only ONE detail line, not two. and the varible needs tied to the box... I hope I understand the correctly.. let me try that. Again thank.

Either I am very confused or havent explained well. Here is what I did. first, I set up a variable, used your suggestion and called it cnt. next, I inserted into the detal band two rows containing the same fields names of name, address, city... etc the first band is shaded with screen, so far...

ok.... got it working.. almost. My only problem is it is insterting two addition bands with no info in between the correct lines.. make sense?

Still working on it... I guess reports arent my stong point.

I think I have good start with this. No, the table is indexed, but I could add a field that will populate numbers to creat the look of 1,2,3,4 etc.... In the print when expression, I put print when myfield = even ( or odd ) thats not correct I know.. what would be a correct syntac for that...

I know there must be a simple method to adding a 10% screen to every other line in a simple report... but it is slipping my mind how to accomplish this.