Search results for query: *

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.

Can a number be a part of a street/road name? Say, 134 56th North Road? I can find no instance of that.. the database is small enough I could catch those later anyway. Still not sure how to write the loop routine though. Although in theory, it looks like what I need to do.

HERE IS AN EXAMPLE OF THE ADDRESSES IN A FILE I AM WORKING ON............................................ 28829ORCHARD LAKE RD 25717POWER RD 28588NORTHWESTERN HWY 315MELFORD 30560BECK RD .............................................. What command or snippet is most useful for...

No, not changing any structures. This is a good start. What utility is it I use? Query analyzer?

Hope you can help me. We lost an employee who is well versed in sql server 2000. I am assigned the task to rescue a job we have. He set up an web based program for us that incorporates the use of a database containing 8 tables. All the functions work well, the web site runs fine also. My problem...

that might be an option Brian.. thanks